|
|
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 |
1343 |
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 |
2254 |
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 |
3187 |
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 |
3289 |
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 |
1912 |
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 |
2676 |
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 |
1596 |
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 |
1476 |
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 |
1527 |
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 |
3611 |
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 |
1448 |
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 |
2408 |
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 |
14726 |
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 |
6766 |
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 |
1359 |
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 |
1982 |
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 |
1359 |
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 |
1586 |
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 |
3868 |
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 |
5172 |
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 |
41245 |
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 |
5463 |
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 |
5795 |
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 |
3418 |
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 |
1916 |
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 |
1951 |
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 |
1500 |
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 |
1549 |
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 |
2438 |
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 |
7983 |
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 |
10925 |
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 |
2022 |
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 |
2032 |
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 |
2698 |
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 |
3549 |
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 |
1879 |
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 |
1982 |
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 |
1622 |
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 |
4196 |
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 |
2222 |
Tue, 29 May 2007 01:56 By: michael_bialik ![Go to the last message in this topic](/forum/theme/orafaq/images/goto.gif) |