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

    Replies Views Last message
  Sql query is slow
Oracle Database 10g Enterprise Edition Release 10.2.0.3.0 - 64bit Production
By: prashanth7582 on Wed, 26 June 2013
9 759 Thu, 27 June 2013 07:49
By: Andrey_R
  Different Timings between 2 Nodes
Oracle 11g Release2
By: feroze on Wed, 26 June 2013
2 405 Wed, 26 June 2013 16:56
By: feroze
  Top wait events
Oracle ,11.2.0.3.0 , Solaris 10 sparc 64 bit
By: zeeshan047 on Mon, 24 June 2013
2 630 Mon, 24 June 2013 05:30
By: Flyby
  Tuning a SQL query
Oracle Database 10g Release 2
By: guptasum on Mon, 02 May 2011
17 5564 Fri, 21 June 2013 10:15
By: Kevin Meade
  DB designing from performance point of view.
Oracle Database 11g Enterprise Edition Release 11.2.0.1.0
By: Manoj.Gupta.91 on Mon, 17 June 2013
8 657 Mon, 17 June 2013 02:32
By: John Watson
  Tuning a query with an EXISTS clause
Oracle 10.2.0.4 on Solaris 10
By: orausern on Tue, 11 June 2013
4 1029 Fri, 14 June 2013 17:42
By: Kevin Meade
  Performance tuning made easy
Oracle 10g, Windows 7 64 bit
By: stalin4d on Tue, 11 June 2013
9 883 Fri, 14 June 2013 17:33
By: Kevin Meade
  How to Refresh a Materialized view Data.
Oracle 10g, Windows 7 64 bit
By: stalin4d on Wed, 12 June 2013
2 506 Wed, 12 June 2013 06:48
By: stalin4d
  Memory Allocation in 11 G
oracle 11.2.0.3.0 - Windows server 2008 R2
By: muktha_22 on Mon, 10 June 2013
5 656 Mon, 10 June 2013 07:36
By: Michel Cadot
  SQL not using index from application.
Oracle 11gR1
By: kanas on Thu, 06 June 2013
9 885 Mon, 10 June 2013 00:27
By: michael_bialik
  System statistics: demonstration
11.2.0.3
By: John Watson on Thu, 06 June 2013
6 1190 Thu, 06 June 2013 07:12
By: Michel Cadot
  How to avoid repeat where clause in oracle sql
Oracle 11g, Windows
By: murman on Tue, 04 June 2013
2 614 Tue, 04 June 2013 15:20
By: John Watson
  Unable to update newly added column in existing table
Oracle 9.2.0.6, OS - AIX 6.1
By: s.m.ramachandran on Tue, 21 May 2013
15 1605 Mon, 03 June 2013 12:52
By: s.m.ramachandran
  LogMiner Doubt
11.2.0.3.0
By: rishwinger on Mon, 03 June 2013
6 822 Mon, 03 June 2013 03:46
By: Michel Cadot
  High System I/O Wait Class on AWR
Oracle 10.2.0.4 EE 64-bit, Solaris 10
By: cklh2000 on Fri, 04 January 2013
10 4155 Thu, 30 May 2013 09:16
By: sysdba007
  Keep Pool
Oracle 11g
By: orauser001 on Wed, 22 May 2013
5 1549 Thu, 30 May 2013 05:30
By: anjugarg66
  Help required in analyzing Network waits from AWR
Oracle 10.2.0.3 on AIX
By: sysdba007 on Wed, 29 May 2013
3 1262 Thu, 30 May 2013 02:40
By: sysdba007
  Best disk config for SME scale datawarehouse
Oracle std 10Gx64, windows 2008 x64
By: clementstore on Wed, 15 May 2013
2 783 Mon, 20 May 2013 04:27
By: clementstore
  Need help in performance tunning for querying table
oracle 10g
By: supiash on Sun, 19 May 2013
4 466 Sun, 19 May 2013 08:39
By: Michel Cadot
  enable row movement - ok, but why internally this thing is needed
11.2.0.3.0
By: piotrtal on Fri, 17 May 2013
4 3908 Fri, 17 May 2013 14:43
By: Flyby
  commit_write in 10g
Oracle 10g, AIX
By: TRaj on Thu, 16 May 2013
3 664 Fri, 17 May 2013 00:51
By: Michel Cadot
  db cache advice 10g
Oracle 10g, AIX
By: TRaj on Thu, 16 May 2013
2 710 Thu, 16 May 2013 17:55
By: TRaj
  Oracle generates different execution plans for test and prod environments
Oracle Database 11g
By: httr on Wed, 08 May 2013
11 1563 Wed, 15 May 2013 14:07
By: pointers
  Is there any way to have the DB articulate why PDML is blocked
11.2.0.3
By: Roachcoach on Fri, 10 May 2013
10 815 Wed, 15 May 2013 06:17
By: Roachcoach
  why this query is utilizing my undo so rapidly?
By: piotrtal on Sat, 11 May 2013
9 1895 Sat, 11 May 2013 14:39
By: piotrtal
  delete is very slow
10.2.0.4
By: grpatwari on Fri, 26 April 2013
13 1136 Thu, 09 May 2013 16:53
By: alan.kendall@nfl.com
icon5.gif Query performance tuning for ETL
Oracle 11g
By: Pms_SARA07 on Wed, 08 May 2013
2 713 Wed, 08 May 2013 14:59
By: Pms_SARA07
  Does partitioning need constraints to be copied
Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production
By: bhawnakaamra on Sat, 04 May 2013
10 2259 Tue, 07 May 2013 00:02
By: BlackSwan
  Performance for Table analysis
11.2.0.1
By: grpatwari on Fri, 03 May 2013
5 417 Fri, 03 May 2013 08:54
By: BlackSwan
  Ideas for fixing plan cardinality error
By: Kevin Meade on Tue, 30 April 2013
11 911 Wed, 01 May 2013 10:51
By: Kevin Meade
  Oracle Tuning
Oracle 11g
By: orauser001 on Thu, 25 April 2013
7 1002 Tue, 30 April 2013 08:58
By: Kevin Meade
  Sql query running slowly
oracle 10g
By: anand.oracle on Sat, 27 April 2013
2 790 Mon, 29 April 2013 22:45
By: Kevin Meade
  How to Improve query performance
By: panyamravi on Tue, 23 April 2013
5 989 Sun, 28 April 2013 07:02
By: Kevin Meade
  Bind variable issue
Oracle 9i
By: savugar on Fri, 26 April 2013
7 575 Fri, 26 April 2013 06:15
By: John Watson
  v$sql_plan.object_owner incorrect?
By: DKATyler on Thu, 25 April 2013
2 802 Thu, 25 April 2013 11:56
By: DKATyler
  checking the delete performance in the package
10.2.0.4
By: grpatwari on Fri, 12 April 2013
13 1083 Thu, 25 April 2013 03:31
By: grpatwari
icon5.gif alert.log question
Oracle DB 11, SLES 11
By: Shamall on Tue, 23 October 2012
3 1034 Tue, 23 April 2013 03:25
By: Michel Cadot
  update xml eating up a lot of time
11.2.0.2
By: ayush_anand on Wed, 26 September 2012
4 1095 Tue, 23 April 2013 03:22
By: Michel Cadot
  Query Tuning -indexing
Oracle 10g/Solaris
By: prejib on Thu, 14 February 2013
8 1363 Tue, 23 April 2013 02:59
By: Michel Cadot
  Which is correct solution for ORA-01555 - Increase Undo size or Undo retention?
Oracle 10.2.0.3.0 on AIX
By: sysdba007 on Mon, 22 April 2013
13 3520 Mon, 22 April 2013 19:28
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: Fri Oct 31 15:57:38 CDT 2014

Total time taken to generate the page: 0.14597 seconds