|
|
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 |
1900 |
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 |
2471 |
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 |
1729 |
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 |
2113 |
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 |
2267 |
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 |
3805 |
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 |
2215 |
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 |
3472 |
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 |
5939 |
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 |
3671 |
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 |
1770 |
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 |
1828 |
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 |
1724 |
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 |
1777 |
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 |
1858 |
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 |
2493 |
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 |
2420 |
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 |
3529 |
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 |
2822 |
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 |
2293 |
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 |
2798 |
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 |
1823 |
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 |
1807 |
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 |
1800 |
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 |
3445 |
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 |
1937 |
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 |
2117 |
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 |
1983 |
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 |
1757 |
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 |
3724 |
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 |
5035 |
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 |
1722 |
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 |
5357 |
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 |
5805 |
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 |
3032 |
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 |
2175 |
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 |
2433 |
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 |
9794 |
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 |
3752 |
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 |
2112 |
Thu, 06 July 2006 03:12 By: JRowbottom ![Go to the last message in this topic](/forum/theme/orafaq/images/goto.gif) |