|
|
Topic |
Replies |
Views |
Last message |
![The read & unread messages are only tracked for registered users](/forum/theme/orafaq/images/read.png) |
|
Help: Tuning Query |
2 |
1458 |
Wed, 27 June 2007 15:30 By: michael_bialik ![Go to the last message in this topic](/forum/theme/orafaq/images/goto.gif) |
![The read & unread messages are only tracked for registered users](/forum/theme/orafaq/images/read.png) |
![icon5.gif](/forum/images/message_icons/icon5.gif) |
cache hit ratio |
4 |
2371 |
Wed, 27 June 2007 06:56 By: Michel Cadot ![Go to the last message in this topic](/forum/theme/orafaq/images/goto.gif) |
![The read & unread messages are only tracked for registered users](/forum/theme/orafaq/images/read.png) |
|
Long Running SQL - NO entry in Session_LongOps view? By: mymot on Mon, 25 June 2007 |
7 |
3329 |
Tue, 26 June 2007 13:07 By: gintsp ![Go to the last message in this topic](/forum/theme/orafaq/images/goto.gif) |
![The read & unread messages are only tracked for registered users](/forum/theme/orafaq/images/read.png) |
![icon4.gif](/forum/images/message_icons/icon4.gif) |
Fine Tune Insert Statement |
9 |
3435 |
Tue, 26 June 2007 04:45 By: michael_bialik ![Go to the last message in this topic](/forum/theme/orafaq/images/goto.gif) |
![The read & unread messages are only tracked for registered users](/forum/theme/orafaq/images/read.png) |
|
spreport - tuning paramters! By: rons on Tue, 26 June 2007 |
3 |
2034 |
Tue, 26 June 2007 04:41 By: michael_bialik ![Go to the last message in this topic](/forum/theme/orafaq/images/goto.gif) |
![The read & unread messages are only tracked for registered users](/forum/theme/orafaq/images/read.png) |
|
SQL tuning -- need help urgent |
3 |
2785 |
Tue, 26 June 2007 03:00 By: AshaTyagi ![Go to the last message in this topic](/forum/theme/orafaq/images/goto.gif) |
![The read & unread messages are only tracked for registered users](/forum/theme/orafaq/images/read.png) |
|
Finally moving to LMT By: tobyc on Mon, 25 June 2007 |
3 |
1700 |
Mon, 25 June 2007 15:09 By: tobyc ![Go to the last message in this topic](/forum/theme/orafaq/images/goto.gif) |
![The read & unread messages are only tracked for registered users](/forum/theme/orafaq/images/read.png) |
|
shared pool By: sajut on Mon, 25 June 2007 |
1 |
1582 |
Mon, 25 June 2007 01:39 By: Michel Cadot ![Go to the last message in this topic](/forum/theme/orafaq/images/goto.gif) |
![The read & unread messages are only tracked for registered users](/forum/theme/orafaq/images/read.png) |
![icon9.gif](/forum/images/message_icons/icon9.gif) |
10.1 much slower than 10.2? help! |
2 |
1622 |
Thu, 21 June 2007 01:04 By: Magic][ ![Go to the last message in this topic](/forum/theme/orafaq/images/goto.gif) |
![The read & unread messages are only tracked for registered users](/forum/theme/orafaq/images/read.png) |
|
Performance of Update Statement |
10 |
3736 |
Wed, 20 June 2007 15:56 By: michael_bialik ![Go to the last message in this topic](/forum/theme/orafaq/images/goto.gif) |
![The read & unread messages are only tracked for registered users](/forum/theme/orafaq/images/read.png) |
|
Want to use Alias |
1 |
1552 |
Wed, 20 June 2007 07:15 By: Brayan ![Go to the last message in this topic](/forum/theme/orafaq/images/goto.gif) |
![The read & unread messages are only tracked for registered users](/forum/theme/orafaq/images/read.png) |
|
PLan Cost?-Sql Tuning |
6 |
2533 |
Wed, 20 June 2007 01:52 By: Michel Cadot ![Go to the last message in this topic](/forum/theme/orafaq/images/goto.gif) |
![The read & unread messages are only tracked for registered users](/forum/theme/orafaq/images/read.png) |
|
Rebuild index online |
7 |
14849 |
Mon, 18 June 2007 14:54 By: tmathew ![Go to the last message in this topic](/forum/theme/orafaq/images/goto.gif) |
![The read & unread messages are only tracked for registered users](/forum/theme/orafaq/images/read.png) |
|
dbms_advisor |
9 |
6888 |
Mon, 18 June 2007 12:47 By: adee_saleh ![Go to the last message in this topic](/forum/theme/orafaq/images/goto.gif) |
![The read & unread messages are only tracked for registered users](/forum/theme/orafaq/images/read.png) |
|
UPDATE DATE AND TIME OF TABLE By: meeta on Mon, 18 June 2007 |
1 |
1460 |
Mon, 18 June 2007 06:07 By: Michel Cadot ![Go to the last message in this topic](/forum/theme/orafaq/images/goto.gif) |
![The read & unread messages are only tracked for registered users](/forum/theme/orafaq/images/read.png) |
|
Buffer Busy waits, db file scatteredl read, sequential read |
7 |
2106 |
Sat, 16 June 2007 04:39 By: Michel Cadot ![Go to the last message in this topic](/forum/theme/orafaq/images/goto.gif) |
![The read & unread messages are only tracked for registered users](/forum/theme/orafaq/images/read.png) |
|
Improving performance of insert statement |
1 |
1451 |
Fri, 15 June 2007 05:15 By: Michel Cadot ![Go to the last message in this topic](/forum/theme/orafaq/images/goto.gif) |
![The read & unread messages are only tracked for registered users](/forum/theme/orafaq/images/read.png) |
|
query tuning |
2 |
1695 |
Wed, 13 June 2007 15:32 By: michael_bialik ![Go to the last message in this topic](/forum/theme/orafaq/images/goto.gif) |
![The read & unread messages are only tracked for registered users](/forum/theme/orafaq/images/read.png) |
|
SQL Tuning By: Brayan on Mon, 11 June 2007 |
9 |
3996 |
Wed, 13 June 2007 15:29 By: michael_bialik ![Go to the last message in this topic](/forum/theme/orafaq/images/goto.gif) |
![The read & unread messages are only tracked for registered users](/forum/theme/orafaq/images/read.png) |
|
quick tuning By: eb222 on Tue, 15 May 2007 |
8 |
5322 |
Tue, 12 June 2007 01:50 By: amol_umbarkar ![Go to the last message in this topic](/forum/theme/orafaq/images/goto.gif) |
![The read & unread messages are only tracked for registered users](/forum/theme/orafaq/images/read.png) |
|
DELETE with Parallel - Parallel is not working By: mymot on Mon, 28 May 2007 |
7 |
41621 |
Tue, 12 June 2007 00:42 By: amol_umbarkar ![Go to the last message in this topic](/forum/theme/orafaq/images/goto.gif) |
![The read & unread messages are only tracked for registered users](/forum/theme/orafaq/images/read.png) |
|
10g and Index Fast Full scans |
3 |
5574 |
Mon, 11 June 2007 22:53 By: rleishman ![Go to the last message in this topic](/forum/theme/orafaq/images/goto.gif) |
![The read & unread messages are only tracked for registered users](/forum/theme/orafaq/images/read.png) |
|
How do you determine db_cache_size By: mivey4 on Wed, 06 June 2007 |
3 |
5910 |
Mon, 11 June 2007 09:31 By: mivey4 ![Go to the last message in this topic](/forum/theme/orafaq/images/goto.gif) |
![The read & unread messages are only tracked for registered users](/forum/theme/orafaq/images/read.png) |
|
Oracle 9i Performance and Tuning question By: sk003 on Thu, 07 June 2007 |
5 |
3533 |
Fri, 08 June 2007 08:27 By: michael_bialik ![Go to the last message in this topic](/forum/theme/orafaq/images/goto.gif) |
![The read & unread messages are only tracked for registered users](/forum/theme/orafaq/images/read.png) |
|
2 tables same rowcount different size By: Duke on Fri, 08 June 2007 |
8 |
2038 |
Fri, 08 June 2007 06:57 By: Brayan ![Go to the last message in this topic](/forum/theme/orafaq/images/goto.gif) |
![The read & unread messages are only tracked for registered users](/forum/theme/orafaq/images/read.png) |
|
Pipelining Table Functions By: artmt on Mon, 04 June 2007 |
2 |
2059 |
Thu, 07 June 2007 16:03 By: artmt ![Go to the last message in this topic](/forum/theme/orafaq/images/goto.gif) |
![The read & unread messages are only tracked for registered users](/forum/theme/orafaq/images/read.png) |
|
Normal Forms |
2 |
1597 |
Thu, 07 June 2007 10:37 By: DreamzZ ![Go to the last message in this topic](/forum/theme/orafaq/images/goto.gif) |
![The read & unread messages are only tracked for registered users](/forum/theme/orafaq/images/read.png) |
|
Limiting the resources for specific User By: Brayan on Mon, 04 June 2007 |
3 |
1671 |
Wed, 06 June 2007 13:32 By: Michel Cadot ![Go to the last message in this topic](/forum/theme/orafaq/images/goto.gif) |
![The read & unread messages are only tracked for registered users](/forum/theme/orafaq/images/read.png) |
|
PEFSTAT dropped and recreated |
4 |
2557 |
Wed, 06 June 2007 10:48 By: Michel Cadot ![Go to the last message in this topic](/forum/theme/orafaq/images/goto.gif) |
![The read & unread messages are only tracked for registered users](/forum/theme/orafaq/images/read.png) |
|
Problem in QUICK TUNE advisor |
0 |
8088 |
Wed, 06 June 2007 02:00 By: tanmoy1048 ![Go to the last message in this topic](/forum/theme/orafaq/images/goto.gif) |
![The read & unread messages are only tracked for registered users](/forum/theme/orafaq/images/read.png) |
|
dbms_stats.gather_schema_stats causes ORA-01555 |
5 |
11074 |
Wed, 06 June 2007 00:54 By: Michel Cadot ![Go to the last message in this topic](/forum/theme/orafaq/images/goto.gif) |
![The read & unread messages are only tracked for registered users](/forum/theme/orafaq/images/read.png) |
|
Limitation for view |
7 |
2150 |
Mon, 04 June 2007 21:21 By: artmt ![Go to the last message in this topic](/forum/theme/orafaq/images/goto.gif) |
![The read & unread messages are only tracked for registered users](/forum/theme/orafaq/images/read.png) |
|
about patch |
5 |
2147 |
Mon, 04 June 2007 12:01 By: Michel Cadot ![Go to the last message in this topic](/forum/theme/orafaq/images/goto.gif) |
![The read & unread messages are only tracked for registered users](/forum/theme/orafaq/images/read.png) |
|
Please guide how to tune the given query (merged) |
6 |
2828 |
Mon, 04 June 2007 09:40 By: BlackSwan ![Go to the last message in this topic](/forum/theme/orafaq/images/goto.gif) |
![The read & unread messages are only tracked for registered users](/forum/theme/orafaq/images/read.png) |
|
WORK_AREA_SIZE_POLICY = manual |
2 |
3671 |
Mon, 04 June 2007 06:23 By: parthokonar ![Go to the last message in this topic](/forum/theme/orafaq/images/goto.gif) |
![The read & unread messages are only tracked for registered users](/forum/theme/orafaq/images/read.png) |
|
Performance issues with dbms_job |
1 |
1976 |
Fri, 01 June 2007 03:29 By: Michel Cadot ![Go to the last message in this topic](/forum/theme/orafaq/images/goto.gif) |
![The read & unread messages are only tracked for registered users](/forum/theme/orafaq/images/read.png) |
|
PARTITION HELP By: jinga on Thu, 31 May 2007 |
4 |
2098 |
Fri, 01 June 2007 03:12 By: tahpush ![Go to the last message in this topic](/forum/theme/orafaq/images/goto.gif) |
![The read & unread messages are only tracked for registered users](/forum/theme/orafaq/images/read.png) |
|
automatic statspack By: risy_s on Tue, 29 May 2007 |
2 |
1727 |
Thu, 31 May 2007 02:10 By: Brayan ![Go to the last message in this topic](/forum/theme/orafaq/images/goto.gif) |
![The read & unread messages are only tracked for registered users](/forum/theme/orafaq/images/read.png) |
|
HWM in table |
18 |
4359 |
Thu, 31 May 2007 01:06 By: Michel Cadot ![Go to the last message in this topic](/forum/theme/orafaq/images/goto.gif) |
![The read & unread messages are only tracked for registered users](/forum/theme/orafaq/images/read.png) |
|
Need help |
4 |
2332 |
Tue, 29 May 2007 01:56 By: michael_bialik ![Go to the last message in this topic](/forum/theme/orafaq/images/goto.gif) |