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

    Replies Views Last message
  tuning against count with group by clause
oracle 10g
By: manoj12 on Sat, 31 March 2012
4 1250 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 1233 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 2472 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 620 Thu, 05 April 2012 12:25
By: Michel Cadot
  Query tuning - index suggestion
Oracle,10g
By: sathik on Thu, 05 April 2012
3 636 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 1104 Thu, 05 April 2012 06:25
By: LNossov
  ora - 04031
Oracle, 10.2.0.4
By: savugar on Mon, 27 February 2012
6 2054 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 987 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 1310 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 939 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 1140 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 866 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 1035 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 698 Mon, 26 March 2012 04:58
By: Michel Cadot
  Query Tuning
Oracle 9i
By: ajaykumarkona on Fri, 23 March 2012
4 668 Sat, 24 March 2012 05:05
By: cookiemonster
  very slow on insert
oracle 9i
By: dahalbibek on Fri, 23 March 2012
1 1166 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 1186 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 529 Thu, 22 March 2012 07:34
By: S.Rajaram
  Ugly View Not Cooperating
By: scottwmackey on Tue, 20 March 2012
5 579 Thu, 22 March 2012 07:30
By: S.Rajaram
  TABLESPACE EXTENT
11g
By: sathish16787 on Mon, 19 March 2012
13 918 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 652 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 931 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 1150 Mon, 19 March 2012 03:12
By: msol25
  Reading AWR
By: ninan on Tue, 13 March 2012
20 3743 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 680 Thu, 15 March 2012 03:56
By: Littlefoot
  join condition in index
ora 11.2.0.2
By: orarule on Wed, 14 March 2012
19 1339 Thu, 15 March 2012 03:38
By: rleishman
  Need to know Sql ID and text
HP-UX,Oracle 10g
By: pokhraj_d on Wed, 22 February 2012
4 1122 Wed, 14 March 2012 06:18
By: orarule
  Oracle sequence performance
Oracle 10.2.0.4.0, sun solaris
By: a_oracle on Tue, 28 February 2012
20 1560 Wed, 14 March 2012 06:03
By: cookiemonster
  Sql statement taking very time
Oracle E-Business Suite R12
By: Osafa on Fri, 09 March 2012
16 911 Mon, 12 March 2012 05:47
By: Osafa
  Disk i/o
Oracle 11.2.0.2, AIX
By: lg123 on Sun, 11 March 2012
1 775 Sun, 11 March 2012 12:08
By: Michel Cadot
  how oracle organises records in partitions
11gr2
By: gogol_1987 on Fri, 09 March 2012
5 964 Fri, 09 March 2012 04:57
By: gogol_1987
  Disk reads
By: gkrishn on Fri, 02 March 2012
10 714 Fri, 09 March 2012 02:39
By: gkrishn
  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 1039 Thu, 08 March 2012 12:37
By: janakors
  Slow Query
Oracle 10 g
By: RAM_PIPL on Wed, 29 February 2012
3 758 Thu, 01 March 2012 02:09
By: Roachcoach
  Explain plan got changed suddenly
Oracle , 10.2.0.4
By: sathik on Thu, 23 February 2012
3 998 Fri, 24 February 2012 17:00
By: LNossov
icon5.gif Issue with bulk collect over a db link
oracle,10.2.0.3,HP-UX
By: vishith13 on Thu, 23 February 2012
4 1096 Fri, 24 February 2012 06:03
By: vishith
  Function Based Index is not being used
Oracle 10.2.0.4
By: orapratap on Wed, 22 February 2012
7 943 Thu, 23 February 2012 03:45
By: Roachcoach
  how to find top query running on a table
Oracle EE 10.2.0.3 Linux 64-bit
By: freak_vss on Sun, 19 February 2012
2 1380 Mon, 20 February 2012 13:16
By: LNossov
  Oracle parameters - processes, session, and transactions
Oracle 11.2.0.1
By: djmartin on Mon, 13 February 2012
7 8261 Sun, 19 February 2012 23:07
By: djmartin
  application is slow? what to check immediately
oracle 11.2.0.1 RAC of two nodes,solaris10
By: janakors on Thu, 16 February 2012
4 716 Sat, 18 February 2012 16:04
By: LNossov
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 02 23:08:30 CDT 2014

Total time taken to generate the page: 0.27806 seconds