|
|
Topic |
Replies |
Views |
Last message |
![The read & unread messages are only tracked for registered users](/forum/theme/orafaq/images/read.png) |
|
Oracle join problem (full table scan) |
3 |
4993 |
Wed, 02 February 2005 05:55 By: John Smith ![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) |
|
Detrimental effect of many extents By: helen on Tue, 01 February 2005 |
4 |
4421 |
Wed, 02 February 2005 05:15 By: Madonna ofthe Wasps ![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 help me interpret this tkprof |
4 |
3152 |
Tue, 01 February 2005 09:35 By: Andrea Correale ![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) |
|
oracle10g By: Vishal on Tue, 01 February 2005 |
1 |
3121 |
Tue, 01 February 2005 03:56 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) |
|
Temporary tablespace growing very fast |
4 |
4560 |
Mon, 31 January 2005 22:50 By: Vivek Vijai ![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 Cache and Shared Pool By: Sarah on Mon, 31 January 2005 |
2 |
3808 |
Mon, 31 January 2005 11:47 By: Sarah ![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) |
|
Error 942 happened during loading of queue |
1 |
5461 |
Mon, 31 January 2005 06:15 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) |
|
Hidden Parameters . |
1 |
3129 |
Thu, 27 January 2005 21:23 By: Frank ![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) |
|
DML suddenly taking a long time By: Shikha on Tue, 25 January 2005 |
5 |
4639 |
Wed, 26 January 2005 22:11 By: Frank ![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) |
|
Latch waits are 39% of non-idle wait time By: lily on Tue, 25 January 2005 |
1 |
3432 |
Wed, 26 January 2005 09:43 By: KAIn ![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) |
|
Perfomance difference |
2 |
3373 |
Mon, 24 January 2005 22:54 By: Ashok kumar ![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) |
|
Indexes By: Natasha on Mon, 24 January 2005 |
2 |
2665 |
Mon, 24 January 2005 07:12 By: Scott Swank ![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) |
|
join conditions for smaller /larger tables |
1 |
3306 |
Mon, 24 January 2005 02:25 By: Tony Andrews ![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) |
|
What if index using index is not sufficient By: Vinu on Thu, 20 January 2005 |
4 |
4251 |
Fri, 21 January 2005 03:58 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) |
|
SLOW TABLE DROPS |
1 |
3057 |
Thu, 20 January 2005 23:29 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) |
|
9i . suddenly started running slow |
2 |
3012 |
Thu, 20 January 2005 21:21 By: Frank ![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) |
|
some questions on tuning. By: Naveen on Thu, 20 January 2005 |
0 |
3543 |
Thu, 20 January 2005 10:15 By: Naveen ![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 performace of oracle 9i application server release 1.0 By: mehul on Thu, 20 January 2005 |
0 |
2969 |
Thu, 20 January 2005 02:31 By: mehul ![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) |
|
Index not being used for query By: Vinu on Sun, 16 January 2005 |
9 |
3140 |
Tue, 18 January 2005 00:44 By: Tony Andrews ![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) |
|
row cache lock: Cache id 8 - dc tables on QUERIES. |
0 |
3886 |
Mon, 17 January 2005 22:39 By: Jonas Rosenthal ![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) |
|
Required Index .(Urgent help) By: Brayan on Fri, 14 January 2005 |
1 |
2877 |
Mon, 17 January 2005 03:52 By: Tony Andrews ![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) |
|
Database reports By: Alan on Fri, 14 January 2005 |
3 |
3509 |
Fri, 14 January 2005 06:26 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) |
|
How much used space percentage set for tablespace? |
1 |
3068 |
Thu, 13 January 2005 23:10 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 enable tracing via ODBC By: Jianhua on Thu, 13 January 2005 |
1 |
3138 |
Thu, 13 January 2005 20:07 By: Frank ![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 much used% we need to keep for this tablespace? |
1 |
2618 |
Thu, 13 January 2005 11:17 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) |
|
Count(*) performance |
2 |
2931 |
Thu, 13 January 2005 06:57 By: Frank ![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) |
|
experience on solid state disks By: Chetan on Tue, 11 January 2005 |
1 |
2975 |
Wed, 12 January 2005 03:10 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) |
|
Execution stats shown on Toad |
2 |
3320 |
Wed, 12 January 2005 02:26 By: James Briar ![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) |
|
Tune SGA urgent By: Raj on Thu, 30 December 2004 |
2 |
3230 |
Tue, 11 January 2005 19:26 By: jp ![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) |
|
checking fragmentation |
1 |
2863 |
Tue, 11 January 2005 19:08 By: jp ![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) |
|
Pl Help: to Tune This query.taking 10 min |
0 |
2948 |
Mon, 10 January 2005 23:40 By: BhavinShah ![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) |
|
Views or Tables? By: cw on Mon, 10 January 2005 |
1 |
2992 |
Mon, 10 January 2005 22:54 By: Frank ![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) |
|
Hidden parameter improve performance: _always_semi_join = FALSE |
0 |
7477 |
Mon, 10 January 2005 12:28 By: Narayan Venkat ![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 connect with oracle database |
1 |
2824 |
Fri, 07 January 2005 19:43 By: talvasson ![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) |
|
Sorting Results |
1 |
2874 |
Fri, 07 January 2005 02:14 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) |
|
when database is full |
1 |
2466 |
Thu, 06 January 2005 20:36 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) |
|
Explain the explain plan By: Fahami on Tue, 04 January 2005 |
3 |
120297 |
Thu, 06 January 2005 04:10 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) |
|
how to make sql&pl/sql mor efficient By: ynody on Tue, 04 January 2005 |
4 |
3589 |
Thu, 06 January 2005 02:52 By: ynody ![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) |
|
Session related Quries |
1 |
2512 |
Tue, 04 January 2005 22:38 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) |
|
Oracle 8/9/10 performance problem |
2 |
3366 |
Tue, 04 January 2005 22:24 By: Shimon Tourgeman ![Go to the last message in this topic](/forum/theme/orafaq/images/goto.gif) |