|
|
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 |
1873 |
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 |
2442 |
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 |
1698 |
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 |
2078 |
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 |
2238 |
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 |
3770 |
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 |
2182 |
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 |
3439 |
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 |
5906 |
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 |
3641 |
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 |
1737 |
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 |
1791 |
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 |
1696 |
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 |
1743 |
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 |
1829 |
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 |
2466 |
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 |
2390 |
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 |
3499 |
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 |
2789 |
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 |
2255 |
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 |
2766 |
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 |
1789 |
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 |
1772 |
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 |
1768 |
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 |
3408 |
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 |
1903 |
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 |
2080 |
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 |
1947 |
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 |
1726 |
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 |
3695 |
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 |
5004 |
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 |
1691 |
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 |
5326 |
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 |
5772 |
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 |
3009 |
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 |
2143 |
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 |
2401 |
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 |
9755 |
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 |
3711 |
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 |
2082 |
Thu, 06 July 2006 03:12 By: JRowbottom ![Go to the last message in this topic](/forum/theme/orafaq/images/goto.gif) |