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 not using index from application.
Oracle 11gR1
By: kanas on Thu, 06 June 2013
9 1636 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 2215 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 1143 Tue, 04 June 2013 15:20
By: John Watson
  Performance tunning
By: arnaud.courbiere on Thu, 30 May 2013
2 1355 Thu, 01 August 2013 23:49
By: BlackSwan
  LogMiner Doubt
11.2.0.3.0
By: rishwinger on Mon, 03 June 2013
6 2196 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 3905 Thu, 30 May 2013 02:40
By: sysdba007
  Keep Pool
Oracle 11g
By: orauser001 on Wed, 22 May 2013
5 3095 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 2417 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 885 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 4378 Fri, 17 May 2013 14:43
By: Flyby
  commit_write in 10g
Oracle 10g, AIX
By: TRaj on Thu, 16 May 2013
3 1255 Fri, 17 May 2013 00:51
By: Michel Cadot
  db cache advice 10g
Oracle 10g, AIX
By: TRaj on Thu, 16 May 2013
2 1084 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 1212 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 3998 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 1327 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 1132 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 2451 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 4500 Tue, 07 May 2013 00:02
By: BlackSwan
  Performance for Table analysis
11.2.0.1
By: grpatwari on Fri, 03 May 2013
5 754 Fri, 03 May 2013 08:54
By: BlackSwan
  Ideas for fixing plan cardinality error
By: Kevin Meade on Tue, 30 April 2013
11 1737 Wed, 01 May 2013 10:51
By: Kevin Meade
  Sql query running slowly
oracle 10g
By: anand.oracle on Sat, 27 April 2013
2 1155 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 2211 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 1397 Thu, 25 April 2013 11:56
By: DKATyler
  How to Improve query performance
By: panyamravi on Tue, 23 April 2013
5 1687 Sun, 28 April 2013 07:02
By: Kevin Meade
  Bind variable issue
Oracle 9i
By: savugar on Fri, 26 April 2013
7 1080 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 14496 Mon, 22 April 2013 19:28
By: Kevin Meade
  Oracle Tuning
Oracle 11g
By: orauser001 on Thu, 25 April 2013
7 1660 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 1895 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 1140 Thu, 18 April 2013 10:39
By: cookiemonster
  Application services
production server
By: lovelyjo on Mon, 15 April 2013
2 870 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 1093 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 1879 Thu, 25 April 2013 03:31
By: grpatwari
  Tune function
Windows 2003, Oracle Database 10g Enterprise Edition Release 10.2.0.4.0
By: rahul1982 on Fri, 12 April 2013
11 1417 Tue, 16 April 2013 09:13
By: cookiemonster
  Regarding trace file &TKprof
By: ramanaapps on Wed, 10 April 2013
1 823 Wed, 10 April 2013 04:19
By: Michel Cadot
  Function takingg too long
Oracle Enterprise 11g
By: Tr0cken on Fri, 05 April 2013
5 921 Mon, 08 April 2013 04:55
By: Michel Cadot
  Clarification on using awrrpti.sql script
Oracle 11.2.0.3.0 , Linux 5.7
By: Jack14 on Thu, 04 April 2013
5 1901 Fri, 05 April 2013 09:45
By: Michel Cadot
  _library_cache_advice
Oracle 10g
By: gatetec on Wed, 03 April 2013
1 1993 Wed, 03 April 2013 17:11
By: BlackSwan
  How to create index
Oracle 11g , Solaris
By: SSharma on Sat, 30 March 2013
3 1168 Wed, 03 April 2013 00:12
By: michael_bialik
  How to find out session consuming high resource in the past?
Oracle 10.2.0.3.0 AIX
By: sysdba007 on Thu, 28 March 2013
8 3530 Thu, 11 April 2013 10:55
By: sysdba007
  Table Partioning Issue
Oracle 11g
By: VersatileAjay on Thu, 28 March 2013
9 1918 Mon, 01 April 2013 05:02
By: VersatileAjay
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 Aug 23 16:31:06 CDT 2017

Total time taken to generate the page: 0.12794 seconds