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

    Replies Views Last message
  Tuning my first query
11GR2 RAC on Windows
By: Kwisatz78 on Wed, 26 October 2011
10 851 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 941 Thu, 27 October 2011 02:31
By: drovnik
  Proving OTT undo reads
In post
By: Roachcoach on Wed, 26 October 2011
3 690 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 527 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 4276 Wed, 26 October 2011 06:01
By: Kevin Meade
  Performance Tuning
Aix
By: sher297 on Sun, 23 October 2011
5 591 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 716 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 983 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 1167 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 7317 Tue, 25 October 2011 02:02
By: LNossov
  Optimize MERGE statement
Oracle 10g
By: tsteinmaurer on Wed, 05 October 2011
10 3262 Mon, 24 October 2011 15:54
By: LNossov
  PL/SQL help (performance)
Win Xp, Oracle 10g
By: rajivn786 on Wed, 19 October 2011
17 773 Sat, 22 October 2011 16:04
By: LNossov
  I/p on tuning select query
Oracle 8i
By: shyamu on Sat, 22 October 2011
3 644 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 562 Fri, 21 October 2011 12:49
By: ThomasG
  Need support for Query performance tuning
Oracle 11g
By: onlijob on Thu, 20 October 2011
10 582 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 3213 Wed, 19 October 2011 17:41
By: LNossov
  Large temporary files
Oracle 9i, Centos
By: ranjit@buddhaair.com on Mon, 17 October 2011
2 698 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 923 Sun, 16 October 2011 00:59
By: Michel Cadot
  QUERY Help
By: venkatlvr on Sat, 15 October 2011
3 546 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 1596 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 2320 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 1122 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 4240 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 666 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 1043 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 695 Tue, 04 October 2011 12:18
By: LNossov
  how to find index to rebuilt
oracle 9i
By: sathish16787 on Mon, 03 October 2011
2 986 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 775 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 655 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 774 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 1033 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 1764 Thu, 29 September 2011 07:00
By: ric90
  Query tuning
oracle 9i
By: sathik on Tue, 27 September 2011
6 733 Wed, 28 September 2011 03:25
By: Flyby
  SQL with more parse
11g
By: gkrishn on Tue, 27 September 2011
6 433 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 670 Thu, 22 September 2011 13:12
By: BlackSwan
  Performance Issue
Oracle 10g, Windows XP
By: a_oracle on Wed, 21 September 2011
9 5868 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 2575 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 1083 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 558 Fri, 16 September 2011 14:26
By: varunvir
  session_cached_cursors
11gr2
By: fairdaus on Mon, 27 June 2011
11 5535 Fri, 16 September 2011 08:25
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: Thu Apr 24 04:38:46 CDT 2014

Total time taken to generate the page: 0.12186 seconds