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 1581 Thu, 27 June 2013 07:49
By: Andrey_R
  Please tune this query.
Oracle 11G
By: ajaykumarkona on Wed, 26 June 2013
24 2948 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 1133 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 1172 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 2000 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 1580 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 1156 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 1684 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 2267 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 1165 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 2292 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 3993 Thu, 30 May 2013 02:40
By: sysdba007
  Keep Pool
Oracle 11g
By: orauser001 on Wed, 22 May 2013
5 3164 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 2484 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 4408 Fri, 17 May 2013 14:43
By: Flyby
  commit_write in 10g
Oracle 10g, AIX
By: TRaj on Thu, 16 May 2013
3 1282 Fri, 17 May 2013 00:51
By: Michel Cadot
  db cache advice 10g
Oracle 10g, AIX
By: TRaj on Thu, 16 May 2013
2 1107 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 4116 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 1372 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 1150 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 6131 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 4604 Tue, 07 May 2013 00:02
By: BlackSwan
  Performance for Table analysis
11.2.0.1
By: grpatwari on Fri, 03 May 2013
5 779 Fri, 03 May 2013 08:54
By: BlackSwan
  Ideas for fixing plan cardinality error
By: Kevin Meade on Tue, 30 April 2013
11 1797 Wed, 01 May 2013 10:51
By: Kevin Meade
  Sql query running slowly
oracle 10g
By: anand.oracle on Sat, 27 April 2013
2 1170 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 2301 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 1428 Thu, 25 April 2013 11:56
By: DKATyler
  How to Improve query performance
By: panyamravi on Tue, 23 April 2013
5 1719 Sun, 28 April 2013 07:02
By: Kevin Meade
  Bind variable issue
Oracle 9i
By: savugar on Fri, 26 April 2013
7 1117 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 15005 Mon, 22 April 2013 19:28
By: Kevin Meade
  Oracle Tuning
Oracle 11g
By: orauser001 on Thu, 25 April 2013
7 1753 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 1959 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 1171 Thu, 18 April 2013 10:39
By: cookiemonster
  Application services
production server
By: lovelyjo on Mon, 15 April 2013
2 920 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 1939 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: Mon Oct 23 13:57:07 CDT 2017

Total time taken to generate the page: 0.01657 seconds