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

    Replies Views Last message
  PERFORMANCE TUNING
By: shashank_kurasrediffmail on Sat, 06 August 2011
1 1084 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 3025 Wed, 03 August 2011 20:34
By: snowball
  enq: TS - contention
10.2.0.4
By: varunvir on Tue, 26 July 2011
14 13211 Mon, 01 August 2011 07:27
By: LNossov
  PERFORMANCE HIT DUE TO NVL FUNCTION
Oracle 9i
By: Fasy on Fri, 29 July 2011
1 1316 Fri, 29 July 2011 07:34
By: Michel Cadot
  BitMap Index Issue
By: abdulrahaman288 on Thu, 21 July 2011
6 1194 Mon, 25 July 2011 22:00
By: rleishman
  query optimization
oracle 10gR2 , Suse Enterprise Linux
By: mr_wee on Thu, 21 July 2011
16 751 Mon, 25 July 2011 01:18
By: michael_bialik
  big table partitioning
oracle 10gR2
By: mr_wee on Tue, 28 June 2011
15 1372 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 1418 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 967 Thu, 21 July 2011 02:42
By: MicroJoey
  Performance Tuning SQL Queries
Oracle 11i Queries
By: petersdj on Tue, 19 July 2011
2 1229 Tue, 19 July 2011 11:24
By: cookiemonster
  DBMS_UTILITY
GET_TIME
By: rakesh1503 on Tue, 19 July 2011
9 1057 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 1380 Mon, 18 July 2011 03:33
By: cookiemonster
  Data dictionary Cache - dc_objects
Oracle 10g
By: Rags123 on Mon, 04 July 2011
27 1836 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 4314 Fri, 15 July 2011 09:15
By: Kevin Meade
  SYSAUX Tablespace
Oracle 10g/Windows XP
By: gxeon on Thu, 14 July 2011
3 2282 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 1036 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 2011 Thu, 14 July 2011 02:33
By: John Watson
  Wait Stats
Oracle 10g/Windows
By: gxeon on Mon, 11 July 2011
4 1135 Wed, 13 July 2011 22:24
By: hkchital
  AWR - licensing question
By: piotrtal on Tue, 12 July 2011
23 4537 Wed, 13 July 2011 04:28
By: piotrtal
  NVL is degraing performance, any alternative
By: goparaju on Mon, 04 July 2011
9 1839 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 804 Wed, 13 July 2011 02:32
By: Michel Cadot
  Reg Segment advisor
Oracle 10g
By: sathik on Mon, 11 July 2011
20 2486 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 961 Fri, 08 July 2011 05:59
By: Michel Cadot
  query optimization
oracle 10g
By: prashant_ora on Thu, 07 July 2011
13 1968 Fri, 08 July 2011 05:51
By: LNossov
  Delete stmt taking so much time
oracle
By: shyamu544 on Thu, 07 July 2011
28 864 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 2657 Thu, 07 July 2011 04:38
By: LNossov
  Query taking more time
Oracle 10g R2
By: raj9999 on Tue, 14 June 2011
15 1728 Wed, 06 July 2011 08:54
By: Kevin Meade
  problem with outlines #2
By: piotrtal on Tue, 05 July 2011
19 1401 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 726 Tue, 05 July 2011 06:34
By: cookiemonster
  Typical Question of Query Performance
By: Manoj.Gupta.91 on Tue, 05 July 2011
3 596 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 878 Tue, 05 July 2011 04:46
By: michael_bialik
  problem with outlines
By: piotrtal on Thu, 30 June 2011
26 1313 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 907 Mon, 04 July 2011 04:25
By: gogol_1987
icon4.gif Performance Tuning in Oracle 10g during Migration - Heavy Insert Optimization
Oracle 10g
By: ajexpert on Tue, 15 April 2008
27 6736 Sun, 03 July 2011 23:27
By: Michel Cadot
  How to measure the sql run time?
Oracle 10.2.0.4.0 64bit , AIX 5.3
By: snowball on Sun, 26 June 2011
12 1802 Sun, 03 July 2011 16:11
By: LNossov
  SQL tuning
By: hannah00 on Thu, 09 June 2011
22 1337 Sat, 02 July 2011 01:25
By: Kevin Meade
  Performance Standard Edition without partitioning
Oracle 11g - RHEL 5
By: pbaldanta on Thu, 16 June 2011
2 584 Sat, 02 July 2011 01:05
By: Kevin Meade
  Oracle hash join
Oracle 9i
By: dushan_st on Thu, 23 June 2011
21 18156 Sat, 02 July 2011 00:26
By: Kevin Meade
  AWR Report network foreground wait events
11.1.0.7.0, Linux
By: kavitagoel00 on Wed, 29 June 2011
8 3851 Thu, 30 June 2011 17:15
By: BlackSwan
  Performance Issue
Oracle 10g, Windows XP
By: a_oracle on Wed, 29 June 2011
1 445 Wed, 29 June 2011 12:50
By: BlackSwan
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 Apr 17 13:41:21 CDT 2014

Total time taken to generate the page: 0.05830 seconds