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

    Replies Views Last message
  SGA_TARGET and shared pool
By: matthew00 on Thu, 25 August 2011
2 892 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 655 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 983 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 3950 Wed, 24 August 2011 19:57
By: Kevin Meade
  application performance
By: matthew00 on Wed, 24 August 2011
1 398 Wed, 24 August 2011 17:51
By: cookiemonster
  Speed up this SQL
Oracle 10g
By: r23rob on Fri, 19 August 2011
2 787 Mon, 22 August 2011 08:16
By: rleishman
  performance tuning PROBLEM
By: shashank_kurasrediffmail on Thu, 18 August 2011
8 1197 Thu, 18 August 2011 11:17
By: BlackSwan
  Need help with tuning
By: naveenreddy on Wed, 17 August 2011
1 519 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 487 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 1634 Wed, 17 August 2011 02:34
By: a_oracle
  Oracle Instance Related Query
Oracle 10g
By: saswatic on Tue, 16 August 2011
2 1096 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 5449 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 1293 Thu, 11 August 2011 13:36
By: SSharma
  Performance tuning for select statement
By: benjamin.tl on Fri, 15 January 2010
19 2368 Thu, 11 August 2011 03:33
By: cookiemonster
  New Trace File
Oracle 11g R1
By: rchenna on Thu, 11 August 2011
3 990 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 14300 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 5297 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 4445 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 810 Sun, 07 August 2011 12:20
By: Michel Cadot
  PERFORMANCE TUNING
By: shashank_kurasrediffmail on Sat, 06 August 2011
1 1155 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 3237 Wed, 03 August 2011 20:34
By: snowball
  enq: TS - contention
10.2.0.4
By: varunvir on Tue, 26 July 2011
14 15530 Mon, 01 August 2011 07:27
By: LNossov
  PERFORMANCE HIT DUE TO NVL FUNCTION
Oracle 9i
By: Fasy on Fri, 29 July 2011
1 1380 Fri, 29 July 2011 07:34
By: Michel Cadot
  BitMap Index Issue
By: abdulrahaman288 on Thu, 21 July 2011
6 1273 Mon, 25 July 2011 22:00
By: rleishman
  query optimization
oracle 10gR2 , Suse Enterprise Linux
By: mr_wee on Thu, 21 July 2011
16 821 Mon, 25 July 2011 01:18
By: michael_bialik
  big table partitioning
oracle 10gR2
By: mr_wee on Tue, 28 June 2011
15 1481 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 1609 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 1033 Thu, 21 July 2011 02:42
By: MicroJoey
  Performance Tuning SQL Queries
Oracle 11i Queries
By: petersdj on Tue, 19 July 2011
2 1374 Tue, 19 July 2011 11:24
By: cookiemonster
  DBMS_UTILITY
GET_TIME
By: rakesh1503 on Tue, 19 July 2011
9 1117 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 1458 Mon, 18 July 2011 03:33
By: cookiemonster
  Data dictionary Cache - dc_objects
Oracle 10g
By: Rags123 on Mon, 04 July 2011
27 1969 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 4456 Fri, 15 July 2011 09:15
By: Kevin Meade
  SYSAUX Tablespace
Oracle 10g/Windows XP
By: gxeon on Thu, 14 July 2011
3 2429 Fri, 15 July 2011 03:06
By: Michel Cadot
  Query Optimization Help - Date-Range Matching results in MERGE JOIN CARTESIAN
Oracle 10gR2 (10.2.0.4)
By: rasa on Mon, 11 July 2011
10 1144 Thu, 14 July 2011 09:39
By: rasa
  alter table.. shrink space command hanging..
Sun OS, 10.2.0.3.0
By: lg123 on Wed, 13 July 2011
2 2100 Thu, 14 July 2011 02:33
By: John Watson
  Wait Stats
Oracle 10g/Windows
By: gxeon on Mon, 11 July 2011
4 1233 Wed, 13 July 2011 22:24
By: hkchital
  AWR - licensing question
By: piotrtal on Tue, 12 July 2011
23 4921 Wed, 13 July 2011 04:28
By: piotrtal
  NVL is degraing performance, any alternative
By: goparaju on Mon, 04 July 2011
9 1947 Wed, 13 July 2011 02:37
By: LNossov
  Help SQL Tuning
Oracle 10.2.0.1 on Suse 10
By: nqtrung on Mon, 11 July 2011
13 881 Wed, 13 July 2011 02:32
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: Thu Aug 28 23:00:31 CDT 2014

Total time taken to generate the page: 0.10701 seconds