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 1580 Thu, 27 June 2013 07:49
By: Andrey_R
  Please tune this query.
Oracle 11G
By: ajaykumarkona on Wed, 26 June 2013
24 2944 Tue, 30 July 2013 04:17
By: Lalit Kumar B
  Top wait events
Oracle ,11.2.0.3.0 , Solaris 10 sparc 64 bit
By: zeeshan047 on Mon, 24 June 2013
2 1132 Mon, 24 June 2013 05:30
By: Flyby
  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 1170 Mon, 17 June 2013 02:32
By: John Watson
  How to Refresh a Materialized view Data.
Oracle 10g, Windows 7 64 bit
By: stalin4d on Wed, 12 June 2013
2 861 Wed, 12 June 2013 06:48
By: stalin4d
  Tuning a query with an EXISTS clause
Oracle 10.2.0.4 on Solaris 10
By: orausern on Tue, 11 June 2013
4 1998 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 1578 Fri, 14 June 2013 17:33
By: Kevin Meade
  Memory Allocation in 11 G
oracle 11.2.0.3.0 - Windows server 2008 R2
By: muktha_22 on Mon, 10 June 2013
5 1152 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 1680 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 2264 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 1164 Tue, 04 June 2013 15:20
By: John Watson
  Performance tunning
By: arnaud.courbiere on Thu, 30 May 2013
2 1371 Thu, 01 August 2013 23:49
By: BlackSwan
  LogMiner Doubt
11.2.0.3.0
By: rishwinger on Mon, 03 June 2013
6 2282 Mon, 03 June 2013 03:46
By: Michel Cadot
  Help required in analyzing Network waits from AWR
Oracle 10.2.0.3 on AIX
By: sysdba007 on Wed, 29 May 2013
3 3983 Thu, 30 May 2013 02:40
By: sysdba007
  Keep Pool
Oracle 11g
By: orauser001 on Wed, 22 May 2013
5 3156 Thu, 30 May 2013 05:30
By: anjugarg66
  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 2481 Mon, 03 June 2013 12:52
By: s.m.ramachandran
  Need help in performance tunning for querying table
oracle 10g
By: supiash on Sun, 19 May 2013
4 906 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 4406 Fri, 17 May 2013 14:43
By: Flyby
  commit_write in 10g
Oracle 10g, AIX
By: TRaj on Thu, 16 May 2013
3 1280 Fri, 17 May 2013 00:51
By: Michel Cadot
  db cache advice 10g
Oracle 10g, AIX
By: TRaj on Thu, 16 May 2013
2 1106 Thu, 16 May 2013 17:55
By: TRaj
  Best disk config for SME scale datawarehouse
Oracle std 10Gx64, windows 2008 x64
By: clementstore on Wed, 15 May 2013
2 1227 Mon, 20 May 2013 04:27
By: clementstore
  why this query is utilizing my undo so rapidly?
By: piotrtal on Sat, 11 May 2013
9 4107 Sat, 11 May 2013 14:39
By: piotrtal
  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 1370 Wed, 15 May 2013 06:17
By: Roachcoach
icon5.gif Query performance tuning for ETL
Oracle 11g
By: Pms_SARA07 on Wed, 08 May 2013
2 1148 Wed, 08 May 2013 14:59
By: Pms_SARA07
  Oracle generates different execution plans for test and prod environments
Oracle Database 11g
By: httr on Wed, 08 May 2013
11 6046 Wed, 15 May 2013 14:07
By: pointers
  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 4598 Tue, 07 May 2013 00:02
By: BlackSwan
  Performance for Table analysis
11.2.0.1
By: grpatwari on Fri, 03 May 2013
5 778 Fri, 03 May 2013 08:54
By: BlackSwan
  Ideas for fixing plan cardinality error
By: Kevin Meade on Tue, 30 April 2013
11 1793 Wed, 01 May 2013 10:51
By: Kevin Meade
  Sql query running slowly
oracle 10g
By: anand.oracle on Sat, 27 April 2013
2 1167 Mon, 29 April 2013 22:45
By: Kevin Meade
  delete is very slow
10.2.0.4
By: grpatwari on Fri, 26 April 2013
13 2294 Thu, 09 May 2013 16:53
By: alan.kendall@nfl.com
  v$sql_plan.object_owner incorrect?
By: DKATyler on Thu, 25 April 2013
2 1426 Thu, 25 April 2013 11:56
By: DKATyler
  How to Improve query performance
By: panyamravi on Tue, 23 April 2013
5 1717 Sun, 28 April 2013 07:02
By: Kevin Meade
  Bind variable issue
Oracle 9i
By: savugar on Fri, 26 April 2013
7 1116 Fri, 26 April 2013 06:15
By: John Watson
  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 14987 Mon, 22 April 2013 19:28
By: Kevin Meade
  Oracle Tuning
Oracle 11g
By: orauser001 on Thu, 25 April 2013
7 1750 Tue, 30 April 2013 08:58
By: Kevin Meade
  Identify performance for a query manually i.e. without STATPACK, AWR, ADDM etc.
Oracle 10g Release 2
By: Manoj.Gupta.91 on Fri, 19 April 2013
12 1955 Mon, 22 April 2013 06:30
By: nlnkapardi
  Performance degrade after 10.2.0.5 patch upgrade and downgrade
10.2.0.4
By: neetesh.jathan on Wed, 17 April 2013
5 1170 Thu, 18 April 2013 10:39
By: cookiemonster
  Application services
production server
By: lovelyjo on Mon, 15 April 2013
2 915 Mon, 15 April 2013 09:31
By: Michel Cadot
  Avg time taken by an execution plan
Oracle 10 G
By: getamaze on Fri, 12 April 2013
7 1129 Fri, 12 April 2013 15:55
By: getamaze
  checking the delete performance in the package
10.2.0.4
By: grpatwari on Fri, 12 April 2013
13 1935 Thu, 25 April 2013 03:31
By: grpatwari
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: Wed Oct 18 11:28:35 CDT 2017

Total time taken to generate the page: 0.13584 seconds