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

    Replies Views Last message
  Proving OTT undo reads
In post
By: Roachcoach on Wed, 26 October 2011
3 1169 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 695 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 7470 Wed, 26 October 2011 06:01
By: Kevin Meade
  Performance Tuning
Aix
By: sher297 on Sun, 23 October 2011
5 804 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 901 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 1543 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 1881 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 9529 Tue, 25 October 2011 02:02
By: LNossov
  Optimize MERGE statement
Oracle 10g
By: tsteinmaurer on Wed, 05 October 2011
10 5148 Mon, 24 October 2011 15:54
By: LNossov
  PL/SQL help (performance)
Win Xp, Oracle 10g
By: rajivn786 on Wed, 19 October 2011
17 1244 Sat, 22 October 2011 16:04
By: LNossov
  I/p on tuning select query
Oracle 8i
By: shyamu on Sat, 22 October 2011
3 992 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 915 Fri, 21 October 2011 12:49
By: ThomasG
  Need support for Query performance tuning
Oracle 11g
By: onlijob on Thu, 20 October 2011
10 905 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 3709 Wed, 19 October 2011 17:41
By: LNossov
  Large temporary files
Oracle 9i, Centos
By: ranjit@buddhaair.com on Mon, 17 October 2011
2 947 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 1337 Sun, 16 October 2011 00:59
By: Michel Cadot
  QUERY Help
By: venkatlvr on Sat, 15 October 2011
3 858 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 2248 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 4091 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 1438 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 5851 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 771 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 1602 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 928 Tue, 04 October 2011 12:18
By: LNossov
  how to find index to rebuilt
oracle 9i
By: sathish16787 on Mon, 03 October 2011
2 1282 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 1090 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 962 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 1011 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 1367 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 2251 Thu, 29 September 2011 07:00
By: ric90
  Query tuning
oracle 9i
By: sathik on Tue, 27 September 2011
6 1214 Wed, 28 September 2011 03:25
By: Flyby
  SQL with more parse
11g
By: gkrishn on Tue, 27 September 2011
6 590 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 919 Thu, 22 September 2011 13:12
By: BlackSwan
  Performance Issue
Oracle 10g, Windows XP
By: a_oracle on Wed, 21 September 2011
9 6316 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 3039 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 1841 Sun, 18 September 2011 11:51
By: Kevin Meade
  query taking long time
10.2.0.4
By: varunvir on Fri, 16 September 2011
5 887 Fri, 16 September 2011 14:26
By: varunvir
  session_cached_cursors
11gr2
By: fairdaus on Mon, 27 June 2011
11 9164 Fri, 16 September 2011 08:25
By: Michel Cadot
  select partition issue
11.2.0.1.0 Windos XP
By: andy huang on Thu, 15 September 2011
3 968 Thu, 15 September 2011 20:27
By: BlackSwan
  "NOT IN" REPLACE WITH "MINUS"
Oracle 10gR2
By: thinknightgmailcom on Thu, 15 September 2011
1 971 Thu, 15 September 2011 07:04
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: Mon May 02 03:32:22 CDT 2016

Total time taken to generate the page: 0.17154 seconds