|
|
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 |
5822 |
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 |
4547 |
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 |
3475 |
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 |
2073 |
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 |
2968 |
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 |
2570 |
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 |
2200 |
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 |
2305 |
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 |
2030 |
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 |
7090 |
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 |
2240 |
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 |
2232 |
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 |
4377 |
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 |
2766 |
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 |
1819 |
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 |
2356 |
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 |
1876 |
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 |
1685 |
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 |
3458 |
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 |
1678 |
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 |
1823 |
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 |
2814 |
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 |
4795 |
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 |
1309 |
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 |
1454 |
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 |
1414 |
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 |
2861 |
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 |
7194 |
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 |
1777 |
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 |
2821 |
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 |
3871 |
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 |
21002 |
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 |
3576 |
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 |
6770 |
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 |
5227 |
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 |
1539 |
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 |
1786 |
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 |
2513 |
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 |
3398 |
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 |
1972 |
Tue, 27 January 2009 11:05 By: sonumalhi ![Go to the last message in this topic](/forum/theme/orafaq/images/goto.gif) |