|
|
Topic |
Replies |
Views |
Last message |
![The read & unread messages are only tracked for registered users](/forum/theme/orafaq/images/read.png) |
|
how to get a query into sharable pool ?? |
1 |
1871 |
Thu, 27 July 2006 03:07 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) |
![icon8.gif](/forum/images/message_icons/icon8.gif) |
Very slow in Executing |
2 |
2439 |
Thu, 27 July 2006 02:57 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) |
|
Can someone help with this (image attached) query By: bogey on Wed, 26 July 2006 |
1 |
1695 |
Wed, 26 July 2006 17:01 By: wagnerch ![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) |
|
Help in Performance issue problem |
4 |
2076 |
Wed, 26 July 2006 04:47 By: JRowbottom ![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) |
|
Deleting duplicate rows without subquery |
2 |
2236 |
Tue, 25 July 2006 11:33 By: manish mendiratta ![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) |
|
RBO to CBO Conversion |
9 |
3763 |
Tue, 25 July 2006 09:13 By: JSI2001 ![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) |
|
Data Type Mismatch |
3 |
2180 |
Mon, 24 July 2006 06:44 By: JRowbottom ![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) |
![icon13.gif](/forum/images/message_icons/icon13.gif) |
urgent- help me |
9 |
3432 |
Mon, 24 July 2006 05:10 By: JRowbottom ![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) |
|
Bitmap Index and Histogram |
9 |
5900 |
Sat, 22 July 2006 18:49 By: srinivas4u2 ![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 Issue Problem |
3 |
3637 |
Thu, 20 July 2006 03:09 By: JRowbottom ![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) |
|
DROP and CREATE INDEX and need for ANALYZE INDEX ... ESTIMATE STATISTICS |
2 |
1732 |
Wed, 19 July 2006 17:27 By: jgarry ![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) |
resize request completion |
1 |
1789 |
Wed, 19 July 2006 02:54 By: JRowbottom ![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) |
|
Where I get the I/O Info? |
1 |
1694 |
Tue, 18 July 2006 20:51 By: Mahesh Rajendran ![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 issue problem |
1 |
1739 |
Tue, 18 July 2006 06:28 By: JRowbottom ![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) |
|
plz help me |
2 |
1823 |
Tue, 18 July 2006 05:59 By: Littlefoot ![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) |
|
Slow insertions |
4 |
2462 |
Mon, 17 July 2006 16:59 By: davidnirvano ![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) |
|
Traceroute and DBLINK |
2 |
2387 |
Mon, 17 July 2006 14:00 By: dmill01 ![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) |
![icon2.gif](/forum/images/message_icons/icon2.gif) |
how can increase buffer hit ratio |
2 |
3492 |
Mon, 17 July 2006 06:59 By: Mahesh Rajendran ![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) |
|
Advice Needed-Free space in tablespace for performance By: dba-k on Sat, 15 July 2006 |
3 |
2783 |
Mon, 17 July 2006 06:49 By: Mahesh Rajendran ![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 takes 2.5 Hrs to run!!!!!! By: rp_in on Fri, 14 July 2006 |
5 |
2253 |
Mon, 17 July 2006 03:16 By: JRowbottom ![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) |
|
"Advice" on shared_pool and buffer cache size |
1 |
2762 |
Thu, 13 July 2006 22:25 By: nmacdannald ![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) |
|
Can we improve this qry. |
2 |
1786 |
Thu, 13 July 2006 22:21 By: nmacdannald ![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) |
|
Compressing indexes that have a timestamp in first column. By: cajohn on Tue, 11 July 2006 |
3 |
1768 |
Thu, 13 July 2006 21:36 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) |
|
Performance Issue |
1 |
1765 |
Thu, 13 July 2006 09:16 By: Frank Naude ![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 to make it faster By: mape on Tue, 11 July 2006 |
5 |
3406 |
Wed, 12 July 2006 18:54 By: wagnerch ![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 Issue |
1 |
1897 |
Wed, 12 July 2006 11:38 By: nmacdannald ![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 deleting rows By: Nau on Wed, 07 June 2006 |
5 |
2076 |
Wed, 12 July 2006 11:35 By: nmacdannald ![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) |
|
Help to split query By: mape on Tue, 11 July 2006 |
2 |
1942 |
Wed, 12 July 2006 01:54 By: mape ![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) |
|
URGENT-Shadow process memory usage growth |
1 |
1722 |
Wed, 12 July 2006 00:29 By: nmacdannald ![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) |
|
Help - Different Plans on Different Versions |
0 |
3693 |
Wed, 12 July 2006 00:11 By: kumarsz ![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) |
SQL Query: slow response time |
8 |
4998 |
Mon, 10 July 2006 21:51 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) |
|
Help - Object Creation and I/O reduction |
1 |
1688 |
Mon, 10 July 2006 06:56 By: Mahesh Rajendran ![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) |
|
Help with explain plans |
9 |
5321 |
Sun, 09 July 2006 22:11 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) |
|
Query tuning with INDEX hint. |
4 |
5769 |
Sun, 09 July 2006 21:56 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) |
|
Performance issue with Analytical function |
4 |
3003 |
Sun, 09 July 2006 11:02 By: apramodh ![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 application By: agowda on Fri, 07 July 2006 |
1 |
2141 |
Fri, 07 July 2006 11:19 By: Art Metzer ![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) |
|
Pro C report not working . Is the problem PC -related ? |
4 |
2396 |
Fri, 07 July 2006 07:37 By: JSI2001 ![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) |
|
VW_NSO_1 !! By: AlinaC on Fri, 07 July 2006 |
1 |
9751 |
Fri, 07 July 2006 07:14 By: Art Metzer ![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) |
|
Why size log_buffer have no equal? |
0 |
3708 |
Thu, 06 July 2006 05:09 By: kamunias ![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) |
|
Report taking long time |
3 |
2078 |
Thu, 06 July 2006 03:12 By: JRowbottom ![Go to the last message in this topic](/forum/theme/orafaq/images/goto.gif) |