Home » RDBMS Server » Performance Tuning
Please read the OraFAQ Forum Guide before posting.
Please contribute good answers to the wiki.

    Replies Views Last message
  Index usage
By: deepak samal on Fri, 20 February 2009
2 2074 Fri, 20 February 2009 21:19
By: rleishman
  Execution Plan (merged)
By: Brayan on Tue, 17 February 2009
22 5990 Fri, 20 February 2009 21:13
By: rleishman
  doubt in Performace tuning
Oracle 10G /Linux
By: dhanamukesh on Wed, 18 February 2009
12 6162 Thu, 19 February 2009 00:48
By: dhanamukesh
  Hard Code values in sql vs lookup
9i
By: ajitpal.s on Mon, 16 February 2009
7 4737 Wed, 18 February 2009 21:13
By: ajitpal.s
  Partition table selfjoin for Time series
oracle 10g
By: test2day on Tue, 17 February 2009
1 3785 Tue, 17 February 2009 22:10
By: rleishman
  Tune a select query which contains a pl/sql table type
By: mnair on Tue, 17 February 2009
1 2551 Tue, 17 February 2009 22:09
By: flyboy
  Not using Index
10.2.0.1, Windows 2003
By: sant_new on Wed, 28 January 2009
14 3238 Tue, 17 February 2009 08:42
By: sant_new
  exchange partition
oracle 10g , unix
By: dr46014 on Fri, 13 February 2009
5 3226 Tue, 17 February 2009 05:13
By: Alessandro Rossi
  Perfoemnace Tunning
Oracle 10g
By: sr_orcl on Sun, 15 February 2009
7 2512 Tue, 17 February 2009 04:30
By: sukhijank
  TkProf-Perormance Tunning (merged)
By: sr_orcl on Mon, 16 February 2009
4 2916 Tue, 17 February 2009 04:21
By: rleishman
  re-write the query to improve performance
By: ind9 on Mon, 16 February 2009
2 2188 Mon, 16 February 2009 06:12
By: ind9
  how to change clustering factor
oracle 9i aix5
By: reyazan on Sat, 14 February 2009
5 8258 Mon, 16 February 2009 05:18
By: Alessandro Rossi
  Inserts to table very slow
solaris, 10g
By: TRaj on Tue, 27 January 2009
5 2836 Sat, 14 February 2009 06:16
By: telang_rajiv
  Performance
10g
By: grpatwari on Wed, 11 February 2009
6 2451 Fri, 13 February 2009 00:12
By: grpatwari
  How to reduce the optimizer cost for the below said query
Oracle 10G /Linux
By: dhanamukesh on Tue, 10 February 2009
13 4907 Thu, 12 February 2009 21:46
By: rleishman
  Environment problem...
9.2.0.6
By: jkmurthy on Thu, 12 February 2009
9 4307 Thu, 12 February 2009 07:50
By: JRowbottom
  Inconsistent query behaviour
9.2.0.6
By: jkmurthy on Thu, 12 February 2009
1 2184 Thu, 12 February 2009 05:15
By: cookiemonster
  procedure tunning (merged)
By: mohannksr on Thu, 05 February 2009
5 3305 Wed, 11 February 2009 14:28
By: Littlefoot
  Using Index hint (merged)
By: Olivia on Tue, 10 February 2009
3 2146 Tue, 10 February 2009 07:54
By: Michel Cadot
  increase Cache size
10g
By: grpatwari on Tue, 10 February 2009
4 1948 Tue, 10 February 2009 04:18
By: JRowbottom
  slowness
10.2.0.1,Windows 2003
By: sant_new on Thu, 05 February 2009
11 3856 Tue, 10 February 2009 04:05
By: JRowbottom
  Perfomence Tuning
By: satishk on Mon, 09 February 2009
1 2024 Mon, 09 February 2009 07:00
By: Michel Cadot
  Slow Import on x64
10g, 10.2.0.3, Windows 2003 x64 Std
By: dedythea on Thu, 05 February 2009
2 2335 Sat, 07 February 2009 19:25
By: dedythea
  update query tuning
By: dr46014 on Thu, 05 February 2009
5 3137 Fri, 06 February 2009 13:11
By: coleing
  Issues with V$SQLTEXT
Oracle 10g R2
By: manusunil on Thu, 05 February 2009
12 5297 Thu, 05 February 2009 14:51
By: manusunil
  Top 5 Events
Linux
By: myana.srinivas1 on Thu, 05 February 2009
1 1472 Thu, 05 February 2009 12:18
By: BlackSwan
  function tunning
9i
By: mohannksr on Thu, 05 February 2009
2 2132 Thu, 05 February 2009 02:08
By: mohannksr
  Tuning on Window Server
10.2.0.2
By: varunvir on Wed, 04 February 2009
2 2077 Wed, 04 February 2009 11:29
By: varunvir
  Choosing execution plan with optimizer_index_caching
9.2.0.7
By: Brayan on Wed, 04 February 2009
2 2986 Wed, 04 February 2009 08:16
By: JRowbottom
  Oracle.exe using above 95% cpu usage
Oracle, 10g, Windows XP
By: skmmmf on Wed, 04 February 2009
1 7843 Wed, 04 February 2009 04:55
By: TomG
  SQL performance Tuning help
ORACLE 10g,Toad 9.1
By: rohit3312@gmail.com on Mon, 02 February 2009
1 2267 Mon, 02 February 2009 14:48
By: Michel Cadot
  High optimizer cost ..Please help me out to tune the query. (merged 4)
By: dhanamukesh on Wed, 28 January 2009
6 4050 Mon, 02 February 2009 07:17
By: cookiemonster
  best performance quries
g11 windows 2003 64bit
By: oferoh on Sun, 01 February 2009
13 4185 Mon, 02 February 2009 03:41
By: rleishman
  what is "count stopkey"?
oracle 10g
By: lzfhope on Thu, 22 January 2009
4 22159 Sat, 31 January 2009 19:28
By: lzfhope
  query tuning
10.2.0.2.
By: varunvir on Mon, 26 January 2009
15 3924 Fri, 30 January 2009 16:49
By: rleishman
  Exchange Partition
Oracle 10g UNIX
By: dr46014 on Wed, 28 January 2009
3 7366 Fri, 30 January 2009 00:58
By: rleishman
  Range Hash Partitioning vs. range partition plus B Tree index (merged)
By: dr46014 on Thu, 29 January 2009
3 5697 Fri, 30 January 2009 00:49
By: rleishman
  explain plan
oeacle 10g
By: rajasekhar857 on Thu, 29 January 2009
2 2024 Thu, 29 January 2009 23:23
By: Mahesh Rajendran
  Materialized View Vs Table functions
Oracle 9i
By: sundaravel_n on Thu, 29 January 2009
2 2424 Thu, 29 January 2009 05:48
By: JRowbottom
  working with tkprof utility
oracle 10g
By: rajasekhar857 on Thu, 29 January 2009
5 3367 Thu, 29 January 2009 05:08
By: Michel Cadot
Goto Forum:
  
Legend New Messages New Messages   No New messages No New messages   Locked (w/ unread messages) Locked (w/ unread messages)   Locked Locked   Moved to another forum Moved to another forum

Current Time: Fri Nov 22 13:06:53 CST 2024