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

    Replies Views Last message
  Slow Join between dba_tab_cols and dba_types
By: ocdeveloper on Wed, 14 November 2012
1 1686 Wed, 14 November 2012 13:20
By: BlackSwan
  How to Tune Long running queries?
Oracle 10.2.0.4
By: orapratap on Wed, 11 April 2012
16 7214 Wed, 25 April 2012 07:41
By: bobbydurrettdba
  Bulk Inserts
Oracle 10.1.0.2
By: arif_md2009 on Mon, 09 April 2012
6 1617 Tue, 10 April 2012 01:48
By: Littlefoot
  Need help on SQL Query in decode function performance tunning
Oracle 10g
By: kgecdeep on Sat, 07 April 2012
2 1675 Sat, 07 April 2012 13:18
By: Michel Cadot
  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 2243 Tue, 10 April 2012 10:24
By: Michel Cadot
  functional index null values
database, 9.2.0.8,hp
By: vladimirhrivnak on Thu, 05 April 2012
2 1017 Thu, 05 April 2012 12:25
By: Michel Cadot
  Query tuning - index suggestion
Oracle,10g
By: sathik on Thu, 05 April 2012
3 1095 Thu, 05 April 2012 09:18
By: BlackSwan
  database statistics
By: priteshranjan.preet on Thu, 05 April 2012
2 1264 Fri, 13 April 2012 08:14
By: priteshranjan.preet
  Tuning for slow Oracle query
Oracle database 11.2.0.2.0
By: trowsdale on Wed, 04 April 2012
13 3791 Fri, 06 April 2012 09:44
By: Bill B
  session doing FTS not appearing in longops
Oracle 10.2.0.4
By: orapratap on Wed, 04 April 2012
6 1505 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 2597 Wed, 04 April 2012 03:17
By: Roachcoach
  Oracle 11g alternates between two execution plans
11g Linux
By: viktordt on Tue, 03 April 2012
4 2023 Thu, 05 April 2012 06:25
By: LNossov
  Parallel operations not executing with expected degree
Oracle 10.2.0.4
By: orapratap on Mon, 02 April 2012
2 1322 Mon, 02 April 2012 06:01
By: LNossov
  ADDM report
Oracle 10.2.0.4.0,SunOS
By: Jack14 on Wed, 11 April 2012
10 4383 Sun, 15 April 2012 12:01
By: Jack14
  tuning against count with group by clause
oracle 10g
By: manoj12 on Sat, 31 March 2012
4 1869 Sun, 08 April 2012 01:20
By: Michel Cadot
  loop questions
Oracle 10.2.0.4.0 , AIX 5.3 64bit
By: snowball on Wed, 28 March 2012
3 1287 Sun, 15 April 2012 01:35
By: Kevin Meade
  How to decide Partiitioning columns?
Oracle 10.2.0.4
By: orapratap on Wed, 28 March 2012
21 1621 Fri, 30 March 2012 00:58
By: John Watson
  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 1919 Sat, 31 March 2012 03:57
By: cookiemonster
  Optimiser Cost Caclulation for nested loop join
linux, oracle 10g
By: rekha.singhal@tcs.com on Tue, 27 March 2012
7 1518 Tue, 27 March 2012 06:53
By: Michel Cadot
  Query Tuning
Oracle 9i
By: ajaykumarkona on Fri, 23 March 2012
4 1256 Sat, 24 March 2012 05:05
By: cookiemonster
  Query on the performance of JOIN on indexed columns
Oracle 10.2.0.4
By: orapratap on Fri, 23 March 2012
4 1632 Wed, 25 April 2012 22:15
By: zengmuansha
  Oracle Apps/Software installed in a dB Server
Oracle 11g, 11.2.0.2.0, AIX
By: reym21 on Thu, 22 March 2012
6 1753 Tue, 17 April 2012 01:59
By: John Watson
  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 956 Thu, 22 March 2012 07:34
By: S.Rajaram
  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 1466 Tue, 20 March 2012 08:56
By: Michel Cadot
  New User Help Me Out (merged 2)
Oracle 11gR2, Linux
By: shehzaadkareem on Tue, 20 March 2012
6 999 Tue, 20 March 2012 15:45
By: shehzaadkareem
  Understanding Execution Plan of a query
Oracle 10.2.0.4
By: orapratap on Sun, 25 March 2012
7 1159 Mon, 26 March 2012 04:58
By: Michel Cadot
  TABLESPACE EXTENT
11g
By: sathish16787 on Mon, 19 March 2012
13 1286 Wed, 21 March 2012 00:22
By: Michel Cadot
  Ugly View Not Cooperating
By: scottwmackey on Tue, 20 March 2012
5 1114 Thu, 22 March 2012 07:30
By: S.Rajaram
  very slow on insert
oracle 9i
By: dahalbibek on Fri, 23 March 2012
1 1636 Fri, 23 March 2012 13:49
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 1691 Mon, 19 March 2012 03:12
By: msol25
  Wait/Sleep command in SQL
Oracle 11G
By: santoshwithu@gmail.com on Thu, 15 March 2012
1 939 Thu, 15 March 2012 03:56
By: Littlefoot
  DB performance keys
By: Amine on Sat, 17 March 2012
8 1976 Mon, 16 April 2012 00:01
By: Kevin Meade
  join condition in index
ora 11.2.0.2
By: orarule on Wed, 14 March 2012
19 2450 Thu, 15 March 2012 03:38
By: rleishman
  Reading AWR
By: ninan on Tue, 13 March 2012
20 6979 Thu, 15 March 2012 07:33
By: Michel Cadot
  Disk i/o
Oracle 11.2.0.2, AIX
By: lg123 on Sun, 11 March 2012
1 1101 Sun, 11 March 2012 12:08
By: Michel Cadot
  Sql statement taking very time
Oracle E-Business Suite R12
By: Osafa on Fri, 09 March 2012
16 1712 Mon, 12 March 2012 05:47
By: Osafa
  how oracle organises records in partitions
11gr2
By: gogol_1987 on Fri, 09 March 2012
5 1398 Fri, 09 March 2012 04:57
By: gogol_1987
  undo tbalespace full, which is rectified but now having big WAIT
ORACLE 11G R2 (11.2.0.1.0), ASM , SOLARIS 10, RAC of two Nodes
By: janakors on Wed, 07 March 2012
8 1589 Thu, 08 March 2012 12:37
By: janakors
  Gather statistics on SYS objects
Oracle 11.2.0.2.0. Sun OS
By: Jack14 on Wed, 07 March 2012
4 1750 Sun, 29 April 2012 11:15
By: Jack14
  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 2236 Fri, 23 March 2012 05:48
By: S.Rajaram
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: Tue Sep 26 15:12:34 CDT 2017

Total time taken to generate the page: 0.01998 seconds