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

    Replies Views Last message
  doubt in Performace tuning
Oracle 10G /Linux
By: dhanamukesh on Wed, 18 February 2009
12 5613 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 4298 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 3316 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 1951 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 2807 Tue, 17 February 2009 08:42
By: sant_new
  exchange partition
oracle 10g , unix
By: dr46014 on Fri, 13 February 2009
5 2409 Tue, 17 February 2009 05:13
By: Alessandro Rossi
  Perfoemnace Tunning
Oracle 10g
By: sr_orcl on Sun, 15 February 2009
7 2055 Tue, 17 February 2009 04:30
By: sukhijank
  TkProf-Perormance Tunning (merged)
By: sr_orcl on Mon, 16 February 2009
4 2159 Tue, 17 February 2009 04:21
By: rleishman
  re-write the query to improve performance
By: ind9 on Mon, 16 February 2009
2 1873 Mon, 16 February 2009 06:12
By: ind9
  how to change clustering factor
oracle 9i aix5
By: reyazan on Sat, 14 February 2009
5 6924 Mon, 16 February 2009 05:18
By: Alessandro Rossi
  Inserts to table very slow
solaris, 10g
By: TRaj on Tue, 27 January 2009
5 2059 Sat, 14 February 2009 06:16
By: telang_rajiv
  Performance
10g
By: grpatwari on Wed, 11 February 2009
6 2049 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 4108 Thu, 12 February 2009 21:46
By: rleishman
  Environment problem...
9.2.0.6
By: jkmurthy on Thu, 12 February 2009
9 2535 Thu, 12 February 2009 07:50
By: JRowbottom
  Inconsistent query behaviour
9.2.0.6
By: jkmurthy on Thu, 12 February 2009
1 1648 Thu, 12 February 2009 05:15
By: cookiemonster
  procedure tunning (merged)
By: mohannksr on Thu, 05 February 2009
5 2168 Wed, 11 February 2009 14:28
By: Littlefoot
  Using Index hint (merged)
By: Olivia on Tue, 10 February 2009
3 1690 Tue, 10 February 2009 07:54
By: Michel Cadot
  increase Cache size
10g
By: grpatwari on Tue, 10 February 2009
4 1512 Tue, 10 February 2009 04:18
By: JRowbottom
  slowness
10.2.0.1,Windows 2003
By: sant_new on Thu, 05 February 2009
11 3239 Tue, 10 February 2009 04:05
By: JRowbottom
  Perfomence Tuning
By: satishk on Mon, 09 February 2009
1 1527 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 1666 Sat, 07 February 2009 19:25
By: dedythea
  update query tuning
By: dr46014 on Thu, 05 February 2009
5 2646 Fri, 06 February 2009 13:11
By: coleing
  Issues with V$SQLTEXT
Oracle 10g R2
By: manusunil on Thu, 05 February 2009
12 4637 Thu, 05 February 2009 14:51
By: manusunil
  Top 5 Events
Linux
By: myana.srinivas1 on Thu, 05 February 2009
1 1179 Thu, 05 February 2009 12:18
By: BlackSwan
  function tunning
9i
By: mohannksr on Thu, 05 February 2009
2 1323 Thu, 05 February 2009 02:08
By: mohannksr
  Tuning on Window Server
10.2.0.2
By: varunvir on Wed, 04 February 2009
2 1277 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 2722 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 7051 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 1639 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 2676 Mon, 02 February 2009 07:17
By: cookiemonster
  best performance quries
g11 windows 2003 64bit
By: oferoh on Sun, 01 February 2009
13 3711 Mon, 02 February 2009 03:41
By: rleishman
  what is "count stopkey"?
oracle 10g
By: lzfhope on Thu, 22 January 2009
4 20594 Sat, 31 January 2009 19:28
By: lzfhope
  query tuning
10.2.0.2.
By: varunvir on Mon, 26 January 2009
15 3434 Fri, 30 January 2009 16:49
By: rleishman
  Exchange Partition
Oracle 10g UNIX
By: dr46014 on Wed, 28 January 2009
3 6595 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 5065 Fri, 30 January 2009 00:49
By: rleishman
  explain plan
oeacle 10g
By: rajasekhar857 on Thu, 29 January 2009
2 1397 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 1650 Thu, 29 January 2009 05:48
By: JRowbottom
  working with tkprof utility
oracle 10g
By: rajasekhar857 on Thu, 29 January 2009
5 2382 Thu, 29 January 2009 05:08
By: Michel Cadot
  Hash cluster with small (tiny) rows ?
11g
By: chris3110 on Mon, 26 January 2009
5 3244 Wed, 28 January 2009 20:43
By: rleishman
  performance hurt after dropping the parititons
oracle 10.2.0.3 and solaris 10
By: skumar.dba on Thu, 22 January 2009
4 1834 Tue, 27 January 2009 11:05
By: sonumalhi
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: Sat May 18 03:55:25 CDT 2024