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

    Replies Views Last message
  harsh area size and sort area size
By: matthew00 on Mon, 29 August 2011
3 647 Mon, 29 August 2011 11:38
By: John Watson
  Interface table design question
Oracle, 10g
By: ironman12 on Sat, 27 August 2011
5 715 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 2129 Mon, 29 August 2011 06:17
By: kesavansundaram
  RANGE SCAN VS FAST FULL SCAN
By: patneel on Mon, 29 August 2011
3 2921 Mon, 29 August 2011 05:36
By: Michel Cadot
  SQL TUNING
Oracle 10G
By: Bhaskarquadrant on Fri, 26 August 2011
7 627 Sun, 28 August 2011 22:23
By: hkchital
  Managing Large Table
Oracle 10g
By: EbenT on Fri, 26 August 2011
7 1011 Sun, 28 August 2011 20:56
By: Kevin Meade
  SGA_TARGET and shared pool
By: matthew00 on Thu, 25 August 2011
2 898 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 661 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 1000 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 3956 Wed, 24 August 2011 19:57
By: Kevin Meade
  application performance
By: matthew00 on Wed, 24 August 2011
1 402 Wed, 24 August 2011 17:51
By: cookiemonster
  Speed up this SQL
Oracle 10g
By: r23rob on Fri, 19 August 2011
2 794 Mon, 22 August 2011 08:16
By: rleishman
  performance tuning PROBLEM
By: shashank_kurasrediffmail on Thu, 18 August 2011
8 1214 Thu, 18 August 2011 11:17
By: BlackSwan
  Need help with tuning
By: naveenreddy on Wed, 17 August 2011
1 523 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 492 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 1641 Wed, 17 August 2011 02:34
By: a_oracle
  Oracle Instance Related Query
Oracle 10g
By: saswatic on Tue, 16 August 2011
2 1100 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 5538 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 1306 Thu, 11 August 2011 13:36
By: SSharma
  Performance tuning for select statement
By: benjamin.tl on Fri, 15 January 2010
19 2392 Thu, 11 August 2011 03:33
By: cookiemonster
  New Trace File
Oracle 11g R1
By: rchenna on Thu, 11 August 2011
3 999 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 14333 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 5337 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 4525 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 815 Sun, 07 August 2011 12:20
By: Michel Cadot
  PERFORMANCE TUNING
By: shashank_kurasrediffmail on Sat, 06 August 2011
1 1162 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 3274 Wed, 03 August 2011 20:34
By: snowball
  enq: TS - contention
10.2.0.4
By: varunvir on Tue, 26 July 2011
14 15738 Mon, 01 August 2011 07:27
By: LNossov
  PERFORMANCE HIT DUE TO NVL FUNCTION
Oracle 9i
By: Fasy on Fri, 29 July 2011
1 1393 Fri, 29 July 2011 07:34
By: Michel Cadot
  BitMap Index Issue
By: abdulrahaman288 on Thu, 21 July 2011
6 1301 Mon, 25 July 2011 22:00
By: rleishman
  query optimization
oracle 10gR2 , Suse Enterprise Linux
By: mr_wee on Thu, 21 July 2011
16 946 Mon, 25 July 2011 01:18
By: michael_bialik
  big table partitioning
oracle 10gR2
By: mr_wee on Tue, 28 June 2011
15 1513 Sun, 24 July 2011 03:49
By: mr_wee
  delete statement taking forever
10.2.0.3
By: varunvir on Wed, 20 July 2011
14 1637 Fri, 22 July 2011 13:18
By: varunvir
  Sql Query comsuming time
oracle 11g, Window 2003 Server
By: pradies on Fri, 15 July 2011
5 1043 Thu, 21 July 2011 02:42
By: MicroJoey
  Performance Tuning SQL Queries
Oracle 11i Queries
By: petersdj on Tue, 19 July 2011
2 1401 Tue, 19 July 2011 11:24
By: cookiemonster
  DBMS_UTILITY
GET_TIME
By: rakesh1503 on Tue, 19 July 2011
9 1128 Tue, 19 July 2011 04:31
By: cookiemonster
  How can i force a sql use index range scan
11.2.0.1.0 Windos XP
By: andy huang on Fri, 15 July 2011
10 1471 Mon, 18 July 2011 03:33
By: cookiemonster
  Data dictionary Cache - dc_objects
Oracle 10g
By: Rags123 on Mon, 04 July 2011
27 2000 Sat, 16 July 2011 00:49
By: LNossov
  Precise I3 vs. OEM Grid
9i/10g/11g
By: Kevin Meade on Fri, 15 July 2011
0 4474 Fri, 15 July 2011 09:15
By: Kevin Meade
  SYSAUX Tablespace
Oracle 10g/Windows XP
By: gxeon on Thu, 14 July 2011
3 2457 Fri, 15 July 2011 03:06
By: Michel Cadot
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 Sep 19 09:12:09 CDT 2014

Total time taken to generate the page: 0.11128 seconds