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

    Replies Views Last message
  Stopping optimizer choosing concatenation
Oracle9i Enterprise Edition Release 9.2.0.8.0 - 64bit Production
By: Roachcoach on Wed, 07 September 2011
2 636 Wed, 07 September 2011 07:42
By: Roachcoach
icon5.gif Statspack unit information
Oracle database, Standard 10.0.2.4, Windows 2003
By: Flyby on Tue, 06 September 2011
2 908 Tue, 06 September 2011 14:19
By: Flyby
  dml is very slowly when table have many rows
11.2.0.1.0 Windos XP
By: andy huang on Sun, 04 September 2011
6 651 Mon, 05 September 2011 02:45
By: Michel Cadot
  performance tuning
oracle 10g
By: zodiacsom on Fri, 02 September 2011
2 599 Fri, 02 September 2011 13:15
By: flyboy
  Query Performance Issue (4 Merged)
Oracle 10 G
By: mani_rbs on Wed, 31 August 2011
9 923 Fri, 02 September 2011 09:33
By: BlackSwan
  Oracle Database 10g Enterprise Edition Release 10.2.0.4.0 - 64bi
how we can match variable sga in v$sga with v$sgastat view
By: msol25 on Fri, 02 September 2011
5 1256 Fri, 02 September 2011 05:25
By: Michel Cadot
  Memory Fault Error in Tkprof
Oracle 10g, Unix
By: artisteprasanna on Wed, 31 August 2011
1 1648 Wed, 31 August 2011 23:56
By: BlackSwan
  Importing Partitioning rows from Many Export Files.
oracle version 10g Windows XP
By: muktha_22 on Tue, 30 August 2011
2 494 Tue, 30 August 2011 02:40
By: muktha_22
  different between move and shink table
11g windows
By: andy huang on Fri, 22 July 2011
2 967 Tue, 30 August 2011 01:27
By: jai_subi
  harsh area size and sort area size
By: matthew00 on Mon, 29 August 2011
3 652 Mon, 29 August 2011 11:38
By: John Watson
  Interface table design question
Oracle, 10g
By: ironman12 on Sat, 27 August 2011
5 723 Mon, 29 August 2011 11:21
By: Kevin Meade
  Need to improve speed for UPDATE statement
oracle 11.2.0.1.0 linux 2.6
By: kesavansundaram on Mon, 29 August 2011
0 2132 Mon, 29 August 2011 06:17
By: kesavansundaram
  RANGE SCAN VS FAST FULL SCAN
By: patneel on Mon, 29 August 2011
3 2932 Mon, 29 August 2011 05:36
By: Michel Cadot
  SQL TUNING
Oracle 10G
By: Bhaskarquadrant on Fri, 26 August 2011
7 635 Sun, 28 August 2011 22:23
By: hkchital
  Managing Large Table
Oracle 10g
By: EbenT on Fri, 26 August 2011
7 1017 Sun, 28 August 2011 20:56
By: Kevin Meade
  SGA_TARGET and shared pool
By: matthew00 on Thu, 25 August 2011
2 901 Thu, 25 August 2011 15:24
By: John Watson
  performance doubt
11.2.0.2.0
By: shashank_kurasrediffmail on Thu, 11 August 2011
9 665 Thu, 25 August 2011 07:45
By: Kevin Meade
  Insert / Update Performance due to Triggers (merged 2)
Oracle 9i
By: mjm22 on Wed, 10 August 2011
5 1007 Wed, 24 August 2011 20:41
By: Kevin Meade
  how expensive is unique versus primary key in large table
9.2.0.1.0
By: OraFerro on Mon, 15 August 2011
5 3964 Wed, 24 August 2011 19:57
By: Kevin Meade
  application performance
By: matthew00 on Wed, 24 August 2011
1 407 Wed, 24 August 2011 17:51
By: cookiemonster
  Speed up this SQL
Oracle 10g
By: r23rob on Fri, 19 August 2011
2 801 Mon, 22 August 2011 08:16
By: rleishman
  performance tuning PROBLEM
By: shashank_kurasrediffmail on Thu, 18 August 2011
8 1225 Thu, 18 August 2011 11:17
By: BlackSwan
  Need help with tuning
By: naveenreddy on Wed, 17 August 2011
1 524 Wed, 17 August 2011 14:20
By: Michel Cadot
  2 design alternatives, passing natural key as meaningful foreign key
9.2.0.1.0
By: OraFerro on Wed, 17 August 2011
5 495 Wed, 17 August 2011 03:01
By: Michel Cadot
  Query sub-factoring issue
Oracle 10g,Windows XP
By: a_oracle on Wed, 17 August 2011
4 1657 Wed, 17 August 2011 02:34
By: a_oracle
  Oracle Instance Related Query
Oracle 10g
By: saswatic on Tue, 16 August 2011
2 1105 Wed, 17 August 2011 00:47
By: John Watson
  start with and connect by
Oracle 11g R2 , RHEL4
By: liliek on Mon, 25 July 2011
28 5571 Mon, 15 August 2011 01:39
By: liliek
  Need to decrease the cost as much as possible
Version: Oracle 10.2.0.3.0 OS: Solaris
By: SSharma on Fri, 29 July 2011
11 1317 Thu, 11 August 2011 13:36
By: SSharma
  Performance tuning for select statement
By: benjamin.tl on Fri, 15 January 2010
19 2405 Thu, 11 August 2011 03:33
By: cookiemonster
  New Trace File
Oracle 11g R1
By: rchenna on Thu, 11 August 2011
3 1010 Thu, 11 August 2011 01:33
By: Michel Cadot
  nvl problem i think
11.2.0.2.0
By: shashank_kurasrediffmail on Wed, 10 August 2011
30 14354 Wed, 10 August 2011 22:45
By: shashank_kurasrediffmail
  SGA_MAX_SIZE to more than 2G?
10.2.0.1.0, OS=Windows 2003 server 64 bit with 16G RAM
By: pt12340 on Wed, 10 August 2011
6 5359 Wed, 10 August 2011 22:32
By: BlackSwan
  Simple SQL with High Concurrency Wait Time (cursor: pin S wait on X)
Oracle 10gR2 on AIX 6.1
By: eclipsis on Fri, 05 August 2011
18 4568 Tue, 09 August 2011 06:46
By: LNossov
  Application slow
Oracle 11.1.0.7.0, Unix-HP
By: Smith14 on Sun, 07 August 2011
4 822 Sun, 07 August 2011 12:20
By: Michel Cadot
  PERFORMANCE TUNING
By: shashank_kurasrediffmail on Sat, 06 August 2011
1 1168 Sat, 06 August 2011 10:02
By: Michel Cadot
  How to reduce the consistent gets of this sql
Oracle 10.2.0.4.0 64bit , AIX 5.3 ( 1 2)
By: snowball on Mon, 27 June 2011
72 3300 Wed, 03 August 2011 20:34
By: snowball
  enq: TS - contention
10.2.0.4
By: varunvir on Tue, 26 July 2011
14 15863 Mon, 01 August 2011 07:27
By: LNossov
  PERFORMANCE HIT DUE TO NVL FUNCTION
Oracle 9i
By: Fasy on Fri, 29 July 2011
1 1399 Fri, 29 July 2011 07:34
By: Michel Cadot
  BitMap Index Issue
By: abdulrahaman288 on Thu, 21 July 2011
6 1309 Mon, 25 July 2011 22:00
By: rleishman
  query optimization
oracle 10gR2 , Suse Enterprise Linux
By: mr_wee on Thu, 21 July 2011
16 953 Mon, 25 July 2011 01:18
By: michael_bialik
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: Wed Oct 01 07:49:42 CDT 2014

Total time taken to generate the page: 0.08853 seconds