|
|
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 |
5647 |
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 |
4388 |
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 |
3365 |
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 |
1986 |
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 |
2848 |
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 |
2090 |
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 |
2198 |
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 |
1910 |
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 |
6959 |
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 |
2095 |
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 |
2087 |
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 |
4145 |
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 |
1686 |
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 |
2202 |
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 |
1725 |
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 |
1546 |
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 |
3279 |
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 |
1564 |
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 |
1701 |
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 |
2680 |
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 |
4680 |
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 |
1210 |
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 |
1311 |
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 |
2757 |
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 |
7085 |
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 |
1673 |
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 |
2714 |
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 |
3751 |
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 |
20734 |
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 |
6640 |
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 |
5097 |
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 |
1432 |
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 |
1684 |
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 |
3277 |
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 |
1865 |
Tue, 27 January 2009 11:05 By: sonumalhi ![Go to the last message in this topic](/forum/theme/orafaq/images/goto.gif) |