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

    Replies Views Last message
  BULK COLLECT issue
10.2.0.1
By: andy huang on Tue, 22 May 2012
14 1366 Wed, 23 May 2012 04:42
By: Michel Cadot
  Index skip scan
oracle,11.2.0.2,aix6.1
By: chandusatyam on Sat, 19 May 2012
8 1148 Tue, 22 May 2012 16:30
By: rleishman
  Tune data coming from legacy system into Oracle DB
Oracle 11gR1
By: vivekgupta15 on Tue, 22 May 2012
6 791 Tue, 22 May 2012 14:03
By: vivekgupta15
  Application Slow in EE but fast in XE (2 Merged)
Oracle 10g, Windows 2003
By: syed.dastagir on Tue, 22 May 2012
1 673 Tue, 22 May 2012 09:41
By: BlackSwan
  Query not hitting index on date column
Oracle 10G
By: priyankt on Fri, 18 May 2012
6 928 Tue, 22 May 2012 08:21
By: John Watson
  Problem in Update
ORACLE 10g
By: priyankt on Fri, 11 May 2012
7 1062 Fri, 18 May 2012 03:46
By: priyankt
  query slow in application, fast on SQL*Plus executing
Oracle Database 10g(RAC) Enterprise Edition Release 10.2.0.4.0 - 64bit
By: Andrey_R on Mon, 14 May 2012
6 1792 Tue, 15 May 2012 06:08
By: LNossov
  PLSQL taking long time
11.2.0.2.5
By: getzeeshan on Thu, 10 May 2012
5 1077 Fri, 11 May 2012 11:34
By: Kevin Meade
  filesystemio_options=SETALL is slower than ASYNCH, why?
11gr2 hp redhat
By: Kevin Meade on Sat, 28 January 2012
7 12663 Fri, 11 May 2012 10:27
By: Kevin Meade
  Query hang
oracle 10g r2,windows 2003 server
By: zeeshan047 on Thu, 10 May 2012
5 1027 Thu, 10 May 2012 08:57
By: Michel Cadot
  Help to alternate or rewrite the query (5 threads merged by bb)
oracle10.2.0.2,Unix
By: krajasekhar.v on Wed, 09 May 2012
2 500 Thu, 10 May 2012 03:07
By: cookiemonster
icon9.gif Slow ─░nsert Fast Select problem
Oracle 10.2.0.4 Enterprise Edition Operation sys Linux
By: fabi88 on Thu, 10 May 2012
1 843 Thu, 10 May 2012 02:14
By: Michel Cadot
  Expplain plan output
10.1.0.1
By: guddu_12 on Wed, 09 May 2012
6 601 Wed, 09 May 2012 07:29
By: John Watson
  how to set the sql_profile
10.2.0.1
By: andy huang on Tue, 08 May 2012
2 1029 Tue, 08 May 2012 21:13
By: andy huang
  Performance issue in query
Oracle 10 G
By: rangan.s on Wed, 02 May 2012
3 927 Tue, 08 May 2012 09:52
By: LNossov
  Help required in analyzing AWR report
Oracle 10.2.0.3.0
By: orapratap on Mon, 07 May 2012
6 2366 Tue, 08 May 2012 08:08
By: John Watson
  cannot see a-rows while querying dbms_xplan.display_cursor
Oracle Database 10g Enterprise (RAC) Edition Release 10.2.0.4.0 - 64bit, LINUX
By: Andrey_R on Thu, 03 May 2012
15 2111 Mon, 07 May 2012 10:48
By: Andrey_R
  unexplained performance degradation of PL/SQL procedures
Oracle 10gr2, Solaris 10
By: apaju on Tue, 01 May 2012
12 1201 Mon, 07 May 2012 04:48
By: apaju
  Parallel index with Non-partitioned Noparallel table
Oracle 10.2.0.4
By: orapratap on Mon, 30 April 2012
5 1268 Sat, 05 May 2012 20:31
By: rleishman
  How we can find %age completion of query when is in running status
Oracle Database 10g Enterprise Edition Release 10.2.0.5.0 - 64bit
By: msol25 on Wed, 02 May 2012
35 1328 Sat, 05 May 2012 06:38
By: martijn
  How we can check count for each partition
Oracle Database 10g Enterprise Edition Release 10.2.0.5.0 - 64bit
By: msol25 on Wed, 02 May 2012
12 2177 Wed, 02 May 2012 22:22
By: BlackSwan
  Achieve same execution plan
Oracle Database 10g Enterprise Edition Release 10.2.0.4.0 - 64bit
By: manubatham20 on Mon, 30 April 2012
9 850 Wed, 02 May 2012 09:46
By: LNossov
  How to change the execution order
Oracle,11g,AIX
By: vattigunta on Wed, 02 May 2012
3 1085 Wed, 02 May 2012 08:30
By: cookiemonster
  Gather statistics on SYS objects
Oracle 11.2.0.2.0. Sun OS
By: Jack14 on Wed, 07 March 2012
4 1322 Sun, 29 April 2012 11:15
By: Jack14
  Query Running for a long time in Second Schema
Oracle 11G
By: gan.chowdary on Fri, 27 April 2012
2 639 Sat, 28 April 2012 19:14
By: rleishman
  Stale statistics for table
Oracle 11g,Linux
By: pokhraj_d on Fri, 27 April 2012
3 8738 Fri, 27 April 2012 22:51
By: BlackSwan
  OWB Cube load SQL tuning
119, exadata
By: onlinedev on Fri, 27 April 2012
1 687 Fri, 27 April 2012 13:28
By: BlackSwan
  Lot of time being taken to delete the data from a table
Oracle 10G
By: harsh shah on Fri, 27 April 2012
26 899 Fri, 27 April 2012 07:25
By: John Watson
  Locking of two sessions
Oracle, 10g,Windows
By: manjumagesh on Fri, 27 April 2012
3 746 Fri, 27 April 2012 07:24
By: cookiemonster
  Tablespace full warning
11g
By: najeeb7 on Thu, 26 April 2012
4 1089 Thu, 26 April 2012 07:36
By: BlackSwan
  Querying GTT in Parallel Mode
Oracle 10.2.0.2
By: orapratap on Tue, 24 April 2012
3 1934 Thu, 26 April 2012 00:43
By: orapratap
  Tuneup the SQL
Oracle 11.2.0.1.0 OS RH Linux 5.1
By: javed.khan on Mon, 23 April 2012
7 1255 Wed, 25 April 2012 22:49
By: Kevin Meade
  Troublesome trigger
By: rishwinger on Mon, 23 April 2012
3 653 Wed, 25 April 2012 22:41
By: Kevin Meade
  Query on the performance of JOIN on indexed columns
Oracle 10.2.0.4
By: orapratap on Fri, 23 March 2012
4 1245 Wed, 25 April 2012 22:15
By: zengmuansha
  How to Tune Long running queries?
Oracle 10.2.0.4
By: orapratap on Wed, 11 April 2012
16 3558 Wed, 25 April 2012 07:41
By: bobbydurrettdba
icon7.gif how do oracle filter data?
Oracle Database 10g Enterprise Edition Release 10.2.0.3.0 - 64bi
By: zengmuansha on Sun, 22 April 2012
7 963 Sun, 22 April 2012 22:31
By: BlackSwan
  Oracle Apps/Software installed in a dB Server
Oracle 11g, 11.2.0.2.0, AIX
By: reym21 on Thu, 22 March 2012
6 1270 Tue, 17 April 2012 01:59
By: John Watson
  query with high cpu usage
10.2.0.2
By: varunvir on Tue, 13 January 2009
14 3888 Mon, 16 April 2012 03:48
By: cookiemonster
  DB performance keys
By: Amine on Sat, 17 March 2012
8 1306 Mon, 16 April 2012 00:01
By: Kevin Meade
  ADDM report
Oracle 10.2.0.4.0,SunOS
By: Jack14 on Wed, 11 April 2012
10 2544 Sun, 15 April 2012 12:01
By: Jack14
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: Sun Sep 21 21:48:58 CDT 2014

Total time taken to generate the page: 0.04491 seconds