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

    Replies Views Last message
  Tuneup the SQL
Oracle 11.2.0.1.0 OS RH Linux 5.1
By: javed.khan on Mon, 23 April 2012
7 1410 Wed, 25 April 2012 22:49
By: Kevin Meade
  Troublesome trigger
By: rishwinger on Mon, 23 April 2012
3 697 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 1305 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 3908 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 1028 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 1330 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 4100 Mon, 16 April 2012 03:48
By: cookiemonster
  DB performance keys
By: Amine on Sat, 17 March 2012
8 1391 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 2797 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 819 Sun, 15 April 2012 01:35
By: Kevin Meade
  database statistics
By: priteshranjan.preet on Thu, 05 April 2012
2 905 Fri, 13 April 2012 08:14
By: priteshranjan.preet
  Different explain plan
Oracle 11g,Linux
By: pokhraj_d on Fri, 13 April 2012
2 718 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 1215 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 1567 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 1019 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 1388 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 1330 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 2699 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 675 Thu, 05 April 2012 12:25
By: Michel Cadot
  Query tuning - index suggestion
Oracle,10g
By: sathik on Thu, 05 April 2012
3 726 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 1237 Thu, 05 April 2012 06:25
By: LNossov
  ora - 04031
Oracle, 10.2.0.4
By: savugar on Mon, 27 February 2012
6 2272 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 1100 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 1513 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 997 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 1242 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 989 Fri, 30 March 2012 00:58
By: John Watson
  Optimiser Cost Caclulation for nested loop join
linux, oracle 10g
By: rekha.singhal@tcs.com on Tue, 27 March 2012
7 1131 Tue, 27 March 2012 06:53
By: Michel Cadot
  Understanding Execution Plan of a query
Oracle 10.2.0.4
By: orapratap on Sun, 25 March 2012
7 771 Mon, 26 March 2012 04:58
By: Michel Cadot
  Query Tuning
Oracle 9i
By: ajaykumarkona on Fri, 23 March 2012
4 810 Sat, 24 March 2012 05:05
By: cookiemonster
  very slow on insert
oracle 9i
By: dahalbibek on Fri, 23 March 2012
1 1248 Fri, 23 March 2012 13:49
By: Michel Cadot
  On which columns to apply index
Oracle Database 10g Enterprise Edition Release 10.2.0.4.0 - 64bit
By: manubatham20 on Mon, 05 March 2012
15 1336 Fri, 23 March 2012 05:48
By: S.Rajaram
  Order of steps in execution path and order of predicates in the Plan
Oracle 10.2.0.4
By: orapratap on Tue, 20 March 2012
3 603 Thu, 22 March 2012 07:34
By: S.Rajaram
  Ugly View Not Cooperating
By: scottwmackey on Tue, 20 March 2012
5 672 Thu, 22 March 2012 07:30
By: S.Rajaram
  TABLESPACE EXTENT
11g
By: sathish16787 on Mon, 19 March 2012
13 979 Wed, 21 March 2012 00:22
By: Michel Cadot
  New User Help Me Out (merged 2)
Oracle 11gR2, Linux
By: shehzaadkareem on Tue, 20 March 2012
6 726 Tue, 20 March 2012 15:45
By: shehzaadkareem
  Materialized View, which should refresh every Tuesday and Friday at 5am. (merged 2)
Oracle 11.2.0.2.0
By: vishnu_ora on Tue, 20 March 2012
2 1019 Tue, 20 March 2012 08:56
By: Michel Cadot
  How to find Local and global indexes on Particular Table
Oracle 10g Release 2
By: msol25 on Mon, 19 March 2012
2 1283 Mon, 19 March 2012 03:12
By: msol25
  Reading AWR
By: ninan on Tue, 13 March 2012
20 4249 Thu, 15 March 2012 07:33
By: Michel Cadot
  Wait/Sleep command in SQL
Oracle 11G
By: santoshwithu@gmail.com on Thu, 15 March 2012
1 714 Thu, 15 March 2012 03:56
By: Littlefoot
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 Jan 29 21:38:05 CST 2015

Total time taken to generate the page: 0.11928 seconds