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

    Replies Views Last message
  Parallel index with Non-partitioned Noparallel table
Oracle 10.2.0.4
By: orapratap on Mon, 30 April 2012
5 1204 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 1255 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 2064 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 814 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 1035 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 1286 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 616 Sat, 28 April 2012 19:14
By: rleishman
  Stale statistics for table
Oracle 11g,Linux
By: pokhraj_d on Fri, 27 April 2012
3 8151 Fri, 27 April 2012 22:51
By: BlackSwan
  OWB Cube load SQL tuning
119, exadata
By: onlinedev on Fri, 27 April 2012
1 645 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 874 Fri, 27 April 2012 07:25
By: John Watson
  Locking of two sessions
Oracle, 10g,Windows
By: manjumagesh on Fri, 27 April 2012
3 716 Fri, 27 April 2012 07:24
By: cookiemonster
  Tablespace full warning
11g
By: najeeb7 on Thu, 26 April 2012
4 1056 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 1818 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 1210 Wed, 25 April 2012 22:49
By: Kevin Meade
  Troublesome trigger
By: rishwinger on Mon, 23 April 2012
3 640 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 1217 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 3422 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 923 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 1246 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 3797 Mon, 16 April 2012 03:48
By: cookiemonster
  DB performance keys
By: Amine on Sat, 17 March 2012
8 1288 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 2428 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 722 Sun, 15 April 2012 01:35
By: Kevin Meade
  database statistics
By: priteshranjan.preet on Thu, 05 April 2012
2 813 Fri, 13 April 2012 08:14
By: priteshranjan.preet
  Different explain plan
Oracle 11g,Linux
By: pokhraj_d on Fri, 13 April 2012
2 673 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 1069 Thu, 12 April 2012 02:08
By: orapratap
  sql_id and sql_child_id not are null for SQL statement
Oracle 11g R2, Windows Server 2003 sp2
By: Andrey_R on Tue, 10 April 2012
6 1369 Tue, 10 April 2012 10:24
By: Michel Cadot
  Bulk Inserts
Oracle 10.1.0.2
By: arif_md2009 on Mon, 09 April 2012
6 846 Tue, 10 April 2012 01:48
By: Littlefoot
  tuning against count with group by clause
oracle 10g
By: manoj12 on Sat, 31 March 2012
4 1234 Sun, 08 April 2012 01:20
By: Michel Cadot
  Need help on SQL Query in decode function performance tunning
Oracle 10g
By: kgecdeep on Sat, 07 April 2012
2 1207 Sat, 07 April 2012 13:18
By: Michel Cadot
  Tuning for slow Oracle query
Oracle database 11.2.0.2.0
By: trowsdale on Wed, 04 April 2012
13 2430 Fri, 06 April 2012 09:44
By: Bill B
  functional index null values
database, 9.2.0.8,hp
By: vladimirhrivnak on Thu, 05 April 2012
2 597 Thu, 05 April 2012 12:25
By: Michel Cadot
  Query tuning - index suggestion
Oracle,10g
By: sathik on Thu, 05 April 2012
3 622 Thu, 05 April 2012 09:18
By: BlackSwan
  Oracle 11g alternates between two execution plans
11g Linux
By: viktordt on Tue, 03 April 2012
4 1075 Thu, 05 April 2012 06:25
By: LNossov
  ora - 04031
Oracle, 10.2.0.4
By: savugar on Mon, 27 February 2012
6 1987 Thu, 05 April 2012 05:59
By: LNossov
  session doing FTS not appearing in longops
Oracle 10.2.0.4
By: orapratap on Wed, 04 April 2012
6 959 Thu, 05 April 2012 05:43
By: orapratap
  speeding up scanning of internal temporary table (of materialize hint)
Oracle 10.2.0.4
By: orapratap on Tue, 03 April 2012
7 1277 Wed, 04 April 2012 03:17
By: Roachcoach
  Parallel operations not executing with expected degree
Oracle 10.2.0.4
By: orapratap on Mon, 02 April 2012
2 923 Mon, 02 April 2012 06:01
By: LNossov
  Distributed query running slow
Oracle9i Enterprise Edition Release 9.2.0.6.0 / Linux 2.4.21-50.ELsmp #1
By: SSharma on Tue, 27 March 2012
8 1124 Sat, 31 March 2012 03:57
By: cookiemonster
  How to decide Partiitioning columns?
Oracle 10.2.0.4
By: orapratap on Wed, 28 March 2012
21 846 Fri, 30 March 2012 00:58
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: Fri Aug 01 09:06:47 CDT 2014

Total time taken to generate the page: 0.14379 seconds