|
|
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 |
1436 |
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 |
2350 |
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 |
3304 |
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 |
3404 |
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 |
2010 |
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 |
2774 |
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 |
1686 |
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 |
1564 |
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 |
1606 |
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 |
3705 |
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 |
1538 |
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 |
2502 |
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 |
14823 |
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 |
6875 |
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 |
1445 |
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 |
2083 |
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 |
1438 |
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 |
1683 |
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 |
3967 |
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 |
5287 |
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 |
41548 |
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 |
5553 |
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 |
5887 |
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 |
3512 |
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 |
2010 |
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 |
2037 |
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 |
1579 |
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 |
1646 |
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 |
2530 |
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 |
8076 |
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 |
11052 |
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 |
2122 |
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 |
2123 |
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 |
2800 |
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 |
3654 |
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 |
1966 |
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 |
2081 |
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 |
1712 |
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 |
4312 |
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 |
2314 |
Tue, 29 May 2007 01:56 By: michael_bialik ![Go to the last message in this topic](/forum/theme/orafaq/images/goto.gif) |