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

    Replies Views Last message
  performance issue with the query
Oracle 11G
By: ajaykumarkona on Sat, 29 June 2013
8 843 Mon, 01 July 2013 03:27
By: Michel Cadot
  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 753 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 402 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 626 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 5550 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 651 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 1021 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 878 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 504 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 652 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 879 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 1182 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 608 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 1598 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 807 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 4095 Thu, 30 May 2013 09:16
By: sysdba007
  Keep Pool
Oracle 11g
By: orauser001 on Wed, 22 May 2013
5 1537 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 1247 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 775 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 462 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 3905 Fri, 17 May 2013 14:43
By: Flyby
  commit_write in 10g
Oracle 10g, AIX
By: TRaj on Thu, 16 May 2013
3 659 Fri, 17 May 2013 00:51
By: Michel Cadot
  db cache advice 10g
Oracle 10g, AIX
By: TRaj on Thu, 16 May 2013
2 708 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 1549 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 810 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 1884 Sat, 11 May 2013 14:39
By: piotrtal
  delete is very slow
10.2.0.4
By: grpatwari on Fri, 26 April 2013
13 1124 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 712 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 2242 Tue, 07 May 2013 00:02
By: BlackSwan
  Performance for Table analysis
11.2.0.1
By: grpatwari on Fri, 03 May 2013
5 414 Fri, 03 May 2013 08:54
By: BlackSwan
  Ideas for fixing plan cardinality error
By: Kevin Meade on Tue, 30 April 2013
11 903 Wed, 01 May 2013 10:51
By: Kevin Meade
  Oracle Tuning
Oracle 11g
By: orauser001 on Thu, 25 April 2013
7 998 Tue, 30 April 2013 08:58
By: Kevin Meade
  Sql query running slowly
oracle 10g
By: anand.oracle on Sat, 27 April 2013
2 784 Mon, 29 April 2013 22:45
By: Kevin Meade
  How to Improve query performance
By: panyamravi on Tue, 23 April 2013
5 986 Sun, 28 April 2013 07:02
By: Kevin Meade
  Bind variable issue
Oracle 9i
By: savugar on Fri, 26 April 2013
7 572 Fri, 26 April 2013 06:15
By: John Watson
  v$sql_plan.object_owner incorrect?
By: DKATyler on Thu, 25 April 2013
2 796 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 1078 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 1022 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 1087 Tue, 23 April 2013 03:22
By: Michel Cadot
  Query Tuning -indexing
Oracle 10g/Solaris
By: prejib on Thu, 14 February 2013
8 1354 Tue, 23 April 2013 02:59
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 Oct 23 11:43:16 CDT 2014

Total time taken to generate the page: 0.10753 seconds