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

    Replies Views Last message
  how to find the SQL statement which have many hard parse
By: lonion on Thu, 31 May 2012
11 2722 Thu, 14 June 2012 12:41
By: LNossov
icon5.gif Response very slow
oracle database 10g
By: hielh on Thu, 31 May 2012
8 3112 Fri, 13 July 2012 19:44
By: alan.kendall@nfl.com
  Verify statspack
Oracle 9.2.0.8.0,windows
By: Jack14 on Tue, 29 May 2012
5 1175 Tue, 29 May 2012 02:47
By: Michel Cadot
  how to reduce dml locks?
oracle 11.2.0.1.0,windows server 2008 R2
By: vijenderkdba on Thu, 24 May 2012
6 2257 Thu, 28 June 2012 23:22
By: Michel Cadot
  Privilege to run explain plan
Oracle 11.2.0.1.0, Windows
By: Jack14 on Thu, 24 May 2012
9 38625 Fri, 25 May 2012 04:22
By: Jack14
  inbound connection timed out (ORA-3136)
ORACLE DB 10g(64 bit) R2
By: p.anshuman1 on Thu, 24 May 2012
4 7608 Mon, 17 September 2012 13:09
By: Michel Cadot
  BULK COLLECT issue
10.2.0.1
By: andy huang on Tue, 22 May 2012
14 2690 Wed, 23 May 2012 04:42
By: Michel Cadot
  Application Slow in EE but fast in XE (2 Merged)
Oracle 10g, Windows 2003
By: syed.dastagir on Tue, 22 May 2012
1 978 Tue, 22 May 2012 09:41
By: BlackSwan
  Tune data coming from legacy system into Oracle DB
Oracle 11gR1
By: vivekgupta15 on Tue, 22 May 2012
6 1201 Tue, 22 May 2012 14:03
By: vivekgupta15
  Index skip scan
oracle,11.2.0.2,aix6.1
By: chandusatyam on Sat, 19 May 2012
8 2004 Tue, 22 May 2012 16:30
By: rleishman
  Tuning Queries
Oracle 10.1.0.2
By: arif_md2009 on Wed, 16 May 2012
13 1666 Thu, 28 June 2012 15:44
By: alan.kendall@nfl.com
  Query not hitting index on date column
Oracle 10G
By: priyankt on Fri, 18 May 2012
6 1491 Tue, 22 May 2012 08:21
By: John Watson
  Value for sga_target
Oracle 10.2.0.4.0 on AIX 5.3
By: raj9999 on Fri, 15 June 2012
8 3689 Wed, 27 June 2012 23:15
By: Michel Cadot
  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 4130 Tue, 15 May 2012 06:08
By: LNossov
  Problem in Update
ORACLE 10g
By: priyankt on Fri, 11 May 2012
7 1476 Fri, 18 May 2012 03:46
By: priyankt
  PLSQL taking long time
11.2.0.2.5
By: getzeeshan on Thu, 10 May 2012
5 1782 Fri, 11 May 2012 11:34
By: Kevin Meade
  Query hang
oracle 10g r2,windows 2003 server
By: zeeshan047 on Thu, 10 May 2012
5 1450 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 998 Thu, 10 May 2012 03:07
By: cookiemonster
  Expplain plan output
10.1.0.1
By: guddu_12 on Wed, 09 May 2012
6 1187 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 1565 Tue, 08 May 2012 21:13
By: andy huang
  Help required in analyzing AWR report
Oracle 10.2.0.3.0
By: orapratap on Mon, 07 May 2012
6 5040 Tue, 08 May 2012 08:08
By: John Watson
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 1249 Thu, 10 May 2012 02:14
By: Michel Cadot
  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
17 5560 Sun, 14 May 2017 07:18
By: BlackSwan
  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 6844 Wed, 02 May 2012 22:22
By: BlackSwan
  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 2603 Sat, 05 May 2012 06:38
By: martijn
  How to change the execution order
Oracle,11g,AIX
By: vattigunta on Wed, 02 May 2012
3 1932 Wed, 02 May 2012 08:30
By: cookiemonster
  unexplained performance degradation of PL/SQL procedures
Oracle 10gr2, Solaris 10
By: apaju on Tue, 01 May 2012
12 2214 Mon, 07 May 2012 04:48
By: apaju
  Performance issue in query
Oracle 10 G
By: rangan.s on Wed, 02 May 2012
3 1635 Tue, 08 May 2012 09:52
By: LNossov
  Achieve same execution plan
Oracle Database 10g Enterprise Edition Release 10.2.0.4.0 - 64bit
By: manubatham20 on Mon, 30 April 2012
9 1477 Wed, 02 May 2012 09:46
By: LNossov
  Stale statistics for table
Oracle 11g,Linux
By: pokhraj_d on Fri, 27 April 2012
3 20871 Fri, 27 April 2012 22:51
By: BlackSwan
  OWB Cube load SQL tuning
119, exadata
By: onlinedev on Fri, 27 April 2012
1 1311 Fri, 27 April 2012 13:28
By: BlackSwan
  Query Running for a long time in Second Schema
Oracle 11G
By: gan.chowdary on Fri, 27 April 2012
2 982 Sat, 28 April 2012 19:14
By: rleishman
  Tablespace full warning
11g
By: najeeb7 on Thu, 26 April 2012
4 1450 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 3915 Thu, 26 April 2012 00:43
By: orapratap
  Locking of two sessions
Oracle, 10g,Windows
By: manjumagesh on Fri, 27 April 2012
3 1017 Fri, 27 April 2012 07:24
By: cookiemonster
  Parallel index with Non-partitioned Noparallel table
Oracle 10.2.0.4
By: orapratap on Mon, 30 April 2012
5 1943 Sat, 05 May 2012 20:31
By: rleishman
  Troublesome trigger
By: rishwinger on Mon, 23 April 2012
3 1010 Wed, 25 April 2012 22:41
By: Kevin Meade
  Tuneup the SQL
Oracle 11.2.0.1.0 OS RH Linux 5.1
By: javed.khan on Mon, 23 April 2012
7 2236 Wed, 25 April 2012 22:49
By: Kevin Meade
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 1412 Sun, 22 April 2012 22:31
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 1729 Fri, 27 April 2012 07:25
By: John Watson
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 19 19:00:20 CDT 2017

Total time taken to generate the page: 0.01764 seconds