|
|
Topic |
Replies |
Views |
Last message |
![The read & unread messages are only tracked for registered users](/forum/theme/orafaq/images/read.png) |
|
doubt in Performace tuning Oracle 10G /Linux |
12 |
5648 |
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 |
4390 |
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 |
3367 |
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 |
1989 |
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 |
2850 |
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 |
2459 |
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 |
2091 |
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 |
2199 |
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 |
1911 |
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 |
6960 |
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 |
2097 |
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 |
2089 |
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 |
4147 |
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 |
2577 |
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 |
1687 |
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 |
2203 |
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 |
1726 |
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 |
1547 |
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 |
3282 |
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 |
1565 |
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 |
1702 |
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 |
2682 |
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 |
4681 |
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 |
1212 |
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 |
1357 |
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 |
1313 |
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 |
2758 |
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 |
7086 |
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 |
1675 |
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 |
2715 |
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 |
3754 |
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 |
20740 |
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 |
3467 |
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 |
6641 |
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 |
5101 |
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 |
1433 |
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 |
1686 |
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 |
2414 |
Thu, 29 January 2009 05:08 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) |
|
Hash cluster with small (tiny) rows ? 11g |
5 |
3278 |
Wed, 28 January 2009 20:43 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 hurt after dropping the parititons oracle 10.2.0.3 and solaris 10 |
4 |
1869 |
Tue, 27 January 2009 11:05 By: sonumalhi ![Go to the last message in this topic](/forum/theme/orafaq/images/goto.gif) |