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

    Replies Views Last message
  Reading explain plan
11GR2 RAC on Windows
By: Kwisatz78 on Mon, 24 October 2011
4 946 Fri, 28 October 2011 10:21
By: Vackar
  Query performance diff
Oracle 10.2.0.1.0 CentOS 5
By: Vackar on Tue, 25 October 2011
12 966 Fri, 28 October 2011 06:41
By: cookiemonster
  Tuning my first query
11GR2 RAC on Windows
By: Kwisatz78 on Wed, 26 October 2011
10 1275 Thu, 27 October 2011 04:15
By: cookiemonster
icon4.gif Are Stale STATS Any Good
v10.2.0.4 SunOS 5.10 x86_64
By: drovnik on Tue, 18 October 2011
2 1232 Thu, 27 October 2011 02:31
By: drovnik
  Proving OTT undo reads
In post
By: Roachcoach on Wed, 26 October 2011
3 1187 Wed, 26 October 2011 08:50
By: Roachcoach
  Performance Issue after Bulk Insertion
Oracle Database 10g Enterprise Edition Release 10.2.0.4.0 - 64bi
By: Manoj.Gupta.91 on Tue, 04 October 2011
2 701 Wed, 26 October 2011 06:57
By: Kevin Meade
  DECODE in WHERE CLAUSE Performance
Oracle 11g, Windows XP
By: ninan on Mon, 17 October 2011
9 7613 Wed, 26 October 2011 06:01
By: Kevin Meade
  Performance Tuning
Aix
By: sher297 on Sun, 23 October 2011
5 809 Wed, 26 October 2011 04:53
By: Kevin Meade
  executions
10.2.0.4, Windows 2003
By: sant_new on Tue, 25 October 2011
3 906 Tue, 25 October 2011 13:16
By: BlackSwan
  Tracing long running program
10.2.0.4, Windows 2003
By: sant_new on Tue, 25 October 2011
14 1558 Tue, 25 October 2011 12:49
By: Michel Cadot
  Index on Range-List Subpartitions Table using template
Oracle 11.2.0.2.0
By: ric90 on Mon, 24 October 2011
4 1899 Tue, 25 October 2011 08:12
By: LNossov
  Snap IDs not found for awr reports generation
Oracle 11gR2, RHEL 5
By: User01 on Mon, 24 October 2011
15 9603 Tue, 25 October 2011 02:02
By: LNossov
  Optimize MERGE statement
Oracle 10g
By: tsteinmaurer on Wed, 05 October 2011
10 5207 Mon, 24 October 2011 15:54
By: LNossov
  PL/SQL help (performance)
Win Xp, Oracle 10g
By: rajivn786 on Wed, 19 October 2011
17 1266 Sat, 22 October 2011 16:04
By: LNossov
  I/p on tuning select query
Oracle 8i
By: shyamu on Sat, 22 October 2011
3 1012 Sat, 22 October 2011 15:52
By: BlackSwan
  Tune the query..
Oracle 11.1.0.6.0
By: muralikri on Fri, 21 October 2011
12 923 Fri, 21 October 2011 12:49
By: ThomasG
  Need support for Query performance tuning
Oracle 11g
By: onlijob on Thu, 20 October 2011
10 912 Fri, 21 October 2011 02:59
By: Roachcoach
  To verify if a row exists (index range scan)
Oracle 10.2.0.3
By: Its_me_ved on Tue, 18 October 2011
4 3731 Wed, 19 October 2011 17:41
By: LNossov
  Large temporary files
Oracle 9i, Centos
By: ranjit@buddhaair.com on Mon, 17 October 2011
2 954 Mon, 17 October 2011 06:53
By: ranjit@buddhaair.com
  Suggestions of manipulating 3 crores of data
Oracle 8i
By: shyamu on Sat, 15 October 2011
8 1361 Sun, 16 October 2011 00:59
By: Michel Cadot
  QUERY Help
By: venkatlvr on Sat, 15 October 2011
3 864 Sat, 15 October 2011 05:35
By: John Watson
  The query was running before 11g upgrade
11.2.0.2.2
By: getzeeshan on Fri, 07 October 2011
39 2277 Fri, 14 October 2011 09:07
By: getzeeshan
  sga,pga parameter resizing
hp-ux ,oracle 10g(rel 2)
By: dbaoracleinin on Thu, 15 September 2011
5 4124 Wed, 12 October 2011 09:34
By: dbaoracleinin
icon4.gif Slower DB response [Oracle 10g on Solaris 5.10]
Oracle 10g on Solaris 5.10
By: suddhasatwa_bhaumik on Tue, 11 October 2011
4 1445 Tue, 11 October 2011 09:49
By: suddhasatwa_bhaumik
  Performance Issue (merged 2)
Oracle DB,11.2.0.1.0,Linux 2.6.18-194.el5PAE
By: crussed_sonu on Mon, 10 October 2011
16 5928 Tue, 11 October 2011 04:02
By: crussed_sonu
  performance problem (Hit Ratio)
Oracle 10g,windows server 2003
By: oradba123 on Mon, 10 October 2011
2 774 Mon, 10 October 2011 03:53
By: Michel Cadot
  Tuning help needed
Oracle 11.1.0.7.0
By: naveenreddy on Fri, 09 September 2011
18 1629 Wed, 05 October 2011 02:55
By: LNossov
  Very Bad Performance After ReOrg
v92080 Enterprise - SPARC 8 64bit
By: drovnik on Tue, 04 October 2011
3 938 Tue, 04 October 2011 12:18
By: LNossov
  how to find index to rebuilt
oracle 9i
By: sathish16787 on Mon, 03 October 2011
2 1288 Tue, 04 October 2011 11:40
By: LNossov
  don't know why this baseline doesn't work :/
11.2.0.1.0
By: piotrtal on Fri, 16 September 2011
3 1105 Tue, 04 October 2011 10:08
By: LNossov
  How to view the tables which are in the keep buffer cache????
By: Narmada28 on Sat, 01 October 2011
9 966 Mon, 03 October 2011 02:54
By: Narmada28
  Views which will help in tuning SGA and PGA
By: Narmada28 on Sat, 01 October 2011
5 1014 Sat, 01 October 2011 12:05
By: Michel Cadot
  optimizer ignoring USE_HASH hint in MERGE Query
10.2.0.3
By: deepa_balu on Fri, 30 September 2011
2 1374 Fri, 30 September 2011 06:42
By: Michel Cadot
  Virtual Columns : function based very slow
Oracle 11.2.0.2.0
By: ric90 on Thu, 29 September 2011
0 2266 Thu, 29 September 2011 07:00
By: ric90
  Query tuning
oracle 9i
By: sathik on Tue, 27 September 2011
6 1229 Wed, 28 September 2011 03:25
By: Flyby
  SQL with more parse
11g
By: gkrishn on Tue, 27 September 2011
6 593 Tue, 27 September 2011 05:39
By: Roachcoach
  MERGE Statment repetitive subquery refactoring (3 Merged)
Oracle 11g, Windows xP
By: ninan on Thu, 22 September 2011
1 930 Thu, 22 September 2011 13:12
By: BlackSwan
  Performance Issue
Oracle 10g, Windows XP
By: a_oracle on Wed, 21 September 2011
9 6327 Thu, 22 September 2011 07:24
By: a_oracle
  Need help to understand in depth about ORA-01555
Oracle , 9.2.0.8, solaris
By: sathik on Thu, 22 September 2011
6 3053 Thu, 22 September 2011 06:56
By: Michel Cadot
  POWER function slows query way down?
9.2.0.8.0
By: Kevin Meade on Fri, 16 September 2011
14 1875 Sun, 18 September 2011 11:51
By: Kevin Meade
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: Mon May 30 02:30:44 CDT 2016

Total time taken to generate the page: 0.31683 seconds