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

    Replies Views Last message
  Query not hitting index on date column
Oracle 10G
By: priyankt on Fri, 18 May 2012
6 1365 Tue, 22 May 2012 08:21
By: John Watson
  Problem in Update
ORACLE 10g
By: priyankt on Fri, 11 May 2012
7 1402 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 3566 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 1649 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 17633 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 1386 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 903 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 1181 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 1071 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 1509 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 1493 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 4500 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 4583 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 2058 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 1846 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 2336 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 5610 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 1353 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 1793 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 1700 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 940 Sat, 28 April 2012 19:14
By: rleishman
  Stale statistics for table
Oracle 11g,Linux
By: pokhraj_d on Fri, 27 April 2012
3 18508 Fri, 27 April 2012 22:51
By: BlackSwan
  OWB Cube load SQL tuning
119, exadata
By: onlinedev on Fri, 27 April 2012
1 1205 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 1580 Fri, 27 April 2012 07:25
By: John Watson
  Locking of two sessions
Oracle, 10g,Windows
By: manjumagesh on Fri, 27 April 2012
3 979 Fri, 27 April 2012 07:24
By: cookiemonster
  Tablespace full warning
11g
By: najeeb7 on Thu, 26 April 2012
4 1403 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 3588 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 2023 Wed, 25 April 2012 22:49
By: Kevin Meade
  Troublesome trigger
By: rishwinger on Mon, 23 April 2012
3 926 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 1564 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 6371 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 1326 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 1676 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 4843 Mon, 16 April 2012 03:48
By: cookiemonster
  DB performance keys
By: Amine on Sat, 17 March 2012
8 1820 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 4081 Sun, 15 April 2012 12:01
By: Jack14
  loop questions
Oracle 10.2.0.4.0 , AIX 5.3 64bit
By: snowball on Wed, 28 March 2012
3 1185 Sun, 15 April 2012 01:35
By: Kevin Meade
  database statistics
By: priteshranjan.preet on Thu, 05 April 2012
2 1198 Fri, 13 April 2012 08:14
By: priteshranjan.preet
  Different explain plan
Oracle 11g,Linux
By: pokhraj_d on Fri, 13 April 2012
2 864 Fri, 13 April 2012 06:23
By: Michel Cadot
  Partition Pruning Not happening!
Oracle 10.2.0.2
By: orapratap on Thu, 12 April 2012
3 1600 Thu, 12 April 2012 02:08
By: orapratap
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 Feb 20 08:04:30 CST 2017

Total time taken to generate the page: 0.12791 seconds