|
|
Topic |
Replies |
Views |
Last message |
![The read & unread messages are only tracked for registered users](/forum/theme/orafaq/images/read.png) |
|
Index usage |
2 |
2115 |
Fri, 20 February 2009 21:19 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) |
|
Execution Plan (merged) By: Brayan on Tue, 17 February 2009 |
22 |
6076 |
Fri, 20 February 2009 21:13 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) |
|
doubt in Performace tuning Oracle 10G /Linux |
12 |
6250 |
Thu, 19 February 2009 00:48 By: dhanamukesh ![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) |
|
Hard Code values in sql vs lookup 9i |
7 |
4802 |
Wed, 18 February 2009 21:13 By: ajitpal.s ![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 table selfjoin for Time series oracle 10g |
1 |
3831 |
Tue, 17 February 2009 22:10 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) |
|
Tune a select query which contains a pl/sql table type By: mnair on Tue, 17 February 2009 |
1 |
2580 |
Tue, 17 February 2009 22:09 By: flyboy ![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) |
|
Not using Index 10.2.0.1, Windows 2003 |
14 |
3373 |
Tue, 17 February 2009 08:42 By: sant_new ![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) |
|
exchange partition oracle 10g , unix By: dr46014 on Fri, 13 February 2009 |
5 |
3285 |
Tue, 17 February 2009 05:13 By: Alessandro Rossi ![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) |
|
Perfoemnace Tunning Oracle 10g By: sr_orcl on Sun, 15 February 2009 |
7 |
2552 |
Tue, 17 February 2009 04:30 By: sukhijank ![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) |
|
TkProf-Perormance Tunning (merged) By: sr_orcl on Mon, 16 February 2009 |
4 |
2949 |
Tue, 17 February 2009 04:21 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) |
|
re-write the query to improve performance By: ind9 on Mon, 16 February 2009 |
2 |
2246 |
Mon, 16 February 2009 06:12 By: ind9 ![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 change clustering factor oracle 9i aix5 By: reyazan on Sat, 14 February 2009 |
5 |
8304 |
Mon, 16 February 2009 05:18 By: Alessandro Rossi ![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) |
|
Inserts to table very slow solaris, 10g By: TRaj on Tue, 27 January 2009 |
5 |
2895 |
Sat, 14 February 2009 06:16 By: telang_rajiv ![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 10g |
6 |
2498 |
Fri, 13 February 2009 00:12 By: grpatwari ![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 reduce the optimizer cost for the below said query Oracle 10G /Linux |
13 |
4951 |
Thu, 12 February 2009 21:46 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) |
|
Environment problem... 9.2.0.6 |
9 |
4347 |
Thu, 12 February 2009 07:50 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) |
|
Inconsistent query behaviour 9.2.0.6 |
1 |
2226 |
Thu, 12 February 2009 05:15 By: cookiemonster ![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) |
|
procedure tunning (merged) |
5 |
3346 |
Wed, 11 February 2009 14:28 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) |
|
Using Index hint (merged) By: Olivia on Tue, 10 February 2009 |
3 |
2190 |
Tue, 10 February 2009 07: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) |
|
increase Cache size 10g |
4 |
1974 |
Tue, 10 February 2009 04:18 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) |
|
slowness 10.2.0.1,Windows 2003 |
11 |
3900 |
Tue, 10 February 2009 04:05 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) |
|
Perfomence Tuning By: satishk on Mon, 09 February 2009 |
1 |
2062 |
Mon, 09 February 2009 07:00 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) |
|
Slow Import on x64 10g, 10.2.0.3, Windows 2003 x64 Std |
2 |
2380 |
Sat, 07 February 2009 19:25 By: dedythea ![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 query tuning By: dr46014 on Thu, 05 February 2009 |
5 |
3167 |
Fri, 06 February 2009 13:11 By: coleing ![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) |
|
Issues with V$SQLTEXT Oracle 10g R2 |
12 |
5344 |
Thu, 05 February 2009 14:51 By: manusunil ![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) |
|
Top 5 Events Linux |
1 |
1500 |
Thu, 05 February 2009 12:18 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) |
|
function tunning 9i |
2 |
2191 |
Thu, 05 February 2009 02:08 By: mohannksr ![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) |
|
Tuning on Window Server 10.2.0.2 |
2 |
2105 |
Wed, 04 February 2009 11:29 By: varunvir ![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) |
|
Choosing execution plan with optimizer_index_caching 9.2.0.7 By: Brayan on Wed, 04 February 2009 |
2 |
3019 |
Wed, 04 February 2009 08: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) |
|
Oracle.exe using above 95% cpu usage Oracle, 10g, Windows XP By: skmmmf on Wed, 04 February 2009 |
1 |
7896 |
Wed, 04 February 2009 04:55 By: TomG ![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 performance Tuning help ORACLE 10g,Toad 9.1 |
1 |
2298 |
Mon, 02 February 2009 14: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) |
|
High optimizer cost ..Please help me out to tune the query. (merged 4) |
6 |
4103 |
Mon, 02 February 2009 07:17 By: cookiemonster ![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) |
|
best performance quries g11 windows 2003 64bit By: oferoh on Sun, 01 February 2009 |
13 |
4225 |
Mon, 02 February 2009 03:41 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) |
|
what is "count stopkey"? oracle 10g By: lzfhope on Thu, 22 January 2009 |
4 |
22328 |
Sat, 31 January 2009 19:28 By: lzfhope ![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 10.2.0.2. |
15 |
4015 |
Fri, 30 January 2009 16:49 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) |
|
Exchange Partition Oracle 10g UNIX By: dr46014 on Wed, 28 January 2009 |
3 |
7401 |
Fri, 30 January 2009 00:58 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) |
|
Range Hash Partitioning vs. range partition plus B Tree index (merged) By: dr46014 on Thu, 29 January 2009 |
3 |
5756 |
Fri, 30 January 2009 00:49 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) |
|
explain plan oeacle 10g |
2 |
2075 |
Thu, 29 January 2009 23:23 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) |
|
Materialized View Vs Table functions Oracle 9i |
2 |
2471 |
Thu, 29 January 2009 05:48 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) |
|
working with tkprof utility oracle 10g |
5 |
3401 |
Thu, 29 January 2009 05:08 By: Michel Cadot ![Go to the last message in this topic](/forum/theme/orafaq/images/goto.gif) |