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

    Replies Views Last message
  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 1272 Thu, 11 August 2011 13:36
By: SSharma
  Performance tuning for select statement
By: benjamin.tl on Fri, 15 January 2010
19 2354 Thu, 11 August 2011 03:33
By: cookiemonster
  New Trace File
Oracle 11g R1
By: rchenna on Thu, 11 August 2011
3 985 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 14224 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 5161 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 4351 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 802 Sun, 07 August 2011 12:20
By: Michel Cadot
  PERFORMANCE TUNING
By: shashank_kurasrediffmail on Sat, 06 August 2011
1 1136 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 3185 Wed, 03 August 2011 20:34
By: snowball
  enq: TS - contention
10.2.0.4
By: varunvir on Tue, 26 July 2011
14 15145 Mon, 01 August 2011 07:27
By: LNossov
  PERFORMANCE HIT DUE TO NVL FUNCTION
Oracle 9i
By: Fasy on Fri, 29 July 2011
1 1364 Fri, 29 July 2011 07:34
By: Michel Cadot
  BitMap Index Issue
By: abdulrahaman288 on Thu, 21 July 2011
6 1252 Mon, 25 July 2011 22:00
By: rleishman
  query optimization
oracle 10gR2 , Suse Enterprise Linux
By: mr_wee on Thu, 21 July 2011
16 796 Mon, 25 July 2011 01:18
By: michael_bialik
  big table partitioning
oracle 10gR2
By: mr_wee on Tue, 28 June 2011
15 1454 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 1578 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 1020 Thu, 21 July 2011 02:42
By: MicroJoey
  Performance Tuning SQL Queries
Oracle 11i Queries
By: petersdj on Tue, 19 July 2011
2 1333 Tue, 19 July 2011 11:24
By: cookiemonster
  DBMS_UTILITY
GET_TIME
By: rakesh1503 on Tue, 19 July 2011
9 1106 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 1438 Mon, 18 July 2011 03:33
By: cookiemonster
  Data dictionary Cache - dc_objects
Oracle 10g
By: Rags123 on Mon, 04 July 2011
27 1943 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 4423 Fri, 15 July 2011 09:15
By: Kevin Meade
  SYSAUX Tablespace
Oracle 10g/Windows XP
By: gxeon on Thu, 14 July 2011
3 2402 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 1128 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 2088 Thu, 14 July 2011 02:33
By: John Watson
  Wait Stats
Oracle 10g/Windows
By: gxeon on Mon, 11 July 2011
4 1216 Wed, 13 July 2011 22:24
By: hkchital
  AWR - licensing question
By: piotrtal on Tue, 12 July 2011
23 4838 Wed, 13 July 2011 04:28
By: piotrtal
  NVL is degraing performance, any alternative
By: goparaju on Mon, 04 July 2011
9 1915 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 859 Wed, 13 July 2011 02:32
By: Michel Cadot
  Reg Segment advisor
Oracle 10g
By: sathik on Mon, 11 July 2011
20 2600 Tue, 12 July 2011 09:58
By: hkchital
  Sol req : Alternative way of rewriting the query
Oracle 10gr2
By: ganeshkn21 on Wed, 06 July 2011
8 1017 Fri, 08 July 2011 05:59
By: Michel Cadot
  query optimization
oracle 10g
By: prashant_ora on Thu, 07 July 2011
13 3402 Fri, 08 July 2011 05:51
By: LNossov
  Delete stmt taking so much time
oracle
By: shyamu544 on Thu, 07 July 2011
28 1043 Thu, 07 July 2011 09:40
By: cookiemonster
  Become DB import too slow after server reboot
Oracle 10G, Solaris 10
By: Tlg13team on Mon, 04 July 2011
11 2949 Thu, 07 July 2011 04:38
By: LNossov
  Query taking more time
Oracle 10g R2
By: raj9999 on Tue, 14 June 2011
15 1824 Wed, 06 July 2011 08:54
By: Kevin Meade
  problem with outlines #2
By: piotrtal on Tue, 05 July 2011
19 1485 Tue, 05 July 2011 10:17
By: LNossov
  Solution req :Performance issue with partitioned table
Oracle 10gR2
By: ganeshkn21 on Tue, 05 July 2011
3 759 Tue, 05 July 2011 06:34
By: cookiemonster
  Typical Question of Query Performance
By: Manoj.Gupta.91 on Tue, 05 July 2011
3 626 Tue, 05 July 2011 05:24
By: Roachcoach
  Query doing FTS on a big table
Oracle 10g 10.2.0.4.0 on AIX 5.3
By: raj9999 on Fri, 24 June 2011
10 939 Tue, 05 July 2011 04:46
By: michael_bialik
  problem with outlines
By: piotrtal on Thu, 30 June 2011
26 1381 Mon, 04 July 2011 10:32
By: cookiemonster
  how to clear cache for testing tuned code
oracle 11g r2
By: gogol_1987 on Mon, 04 July 2011
4 957 Mon, 04 July 2011 04:25
By: gogol_1987
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 Jul 29 02:11:05 CDT 2014

Total time taken to generate the page: 0.17173 seconds