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

    Replies Views Last message
  AWR
Oracle 10g 10.2.0.1.0/Windows 2003 Server
By: gxeon on Thu, 21 April 2011
6 2526 Sun, 24 April 2011 22:41
By: hkchital
  Kill the process
Linux, Oracle 10.2.0.3.0
By: lg123 on Thu, 21 April 2011
7 2966 Thu, 21 April 2011 18:17
By: BlackSwan
  AUDIT ANALYZE TABLE on 9i database?
9.2.0.8
By: Kevin Meade on Tue, 19 April 2011
2 3305 Wed, 20 April 2011 06:08
By: Kevin Meade
  High CPU Utilization in RAC and Log file sequential Read Event
Oracle, 10.2.0.4.0, AIX .3
By: pchandna1 on Wed, 13 April 2011
2 3663 Mon, 18 April 2011 13:58
By: pchandna1
  Max and delete statment talking lot of time
oracle 9i,9.2.0.8,unix
By: vickey_sagar1 on Fri, 15 April 2011
4 1833 Mon, 18 April 2011 04:21
By: Michel Cadot
  Oracle : Client version < Database version.
8.1.7 vs 10gxe
By: SAKOURA on Fri, 15 April 2011
6 2253 Fri, 15 April 2011 06:50
By: SAKOURA
  Query Hanging with Sequential Read or Latch free Waits
Oracle 9.2.0.6.0 on HP-UX
By: OraKaran on Thu, 07 April 2011
14 7663 Thu, 14 April 2011 09:09
By: S.Rajaram
  subquery optimization (6 threads merged by bb)
By: dave987 on Wed, 30 March 2011
12 4738 Wed, 13 April 2011 12:32
By: Barbara Boehmer
  Tuning Insert
10.1.0.5.0
By: sunny17 on Tue, 12 April 2011
4 3022 Wed, 13 April 2011 02:35
By: cookiemonster
  Shall I kill these process...
Oracle 10g rel 2
By: ramoradba on Mon, 11 April 2011
2 1828 Mon, 11 April 2011 15:01
By: ramoradba
  Hier - Query Perfomance (3 Merged)
By: mnafehm on Mon, 04 April 2011
3 2999 Sat, 09 April 2011 21:04
By: rleishman
  How to index 15 columns when you cannot predict what columns will be used in a where clause?
Oracle DB 10gR2
By: vini_au on Mon, 04 April 2011
12 5106 Fri, 08 April 2011 00:20
By: rleishman
  Why Oracle don't use my predefined index?
Oracle 10G, windows
By: Tlg13team on Thu, 07 April 2011
5 2698 Thu, 07 April 2011 02:43
By: Roachcoach
  Execution plan question
Oracle Database 10g Release 10.2.0.5.0 - 64bit Production
By: Buchas on Tue, 05 April 2011
15 4593 Wed, 06 April 2011 08:29
By: cookiemonster
  Performance tuning of query with self join
By: preethavinay on Wed, 06 April 2011
2 1624 Wed, 06 April 2011 06:08
By: michael_bialik
  how to use index on "ON in MERGE statement"?
10g, windows 2003 server.
By: kang on Wed, 06 April 2011
19 4496 Wed, 06 April 2011 04:59
By: Roachcoach
  Just clarification my mind about redo log file size
Oracle 10G
By: Tlg13team on Wed, 06 April 2011
3 3161 Wed, 06 April 2011 01:16
By: Michel Cadot
  please help me tune this query
By: miroconnect@yahoo.com on Sun, 03 April 2011
3 2283 Mon, 04 April 2011 09:10
By: cookiemonster
  Query getting slowed running in Oracle 10g compared to Oracle 9i
Oracle 10g, Linux
By: ram anand on Wed, 30 March 2011
24 5843 Mon, 04 April 2011 06:35
By: John Watson
  Query not executing (3 Merged)
Oracle 10g
By: ajaykumarkona on Mon, 28 March 2011
11 3237 Mon, 04 April 2011 02:26
By: cookiemonster
  derived column index
oralce 10g
By: miroconnect@yahoo.com on Sat, 02 April 2011
3 2218 Sat, 02 April 2011 08:37
By: BlackSwan
  using between slows query
oralce 10g
By: miroconnect@yahoo.com on Sat, 02 April 2011
1 1985 Sat, 02 April 2011 01:24
By: Michel Cadot
  Performance tuning of query with self join
By: preethavinay on Thu, 31 March 2011
6 3064 Fri, 01 April 2011 02:48
By: Its_me_ved
icon5.gif split a large table to small pieces?
Oracle 10G, Solaris 10
By: Tlg13team on Mon, 28 March 2011
12 3436 Thu, 31 March 2011 03:40
By: Kevin Meade
  Can I use Oracle Hint to use index in a query which uses UNION
Oracle 10g
By: arijitdey80 on Thu, 31 March 2011
1 3184 Thu, 31 March 2011 01:52
By: Michel Cadot
  Why are these explain plans missing some info and messed up like they've been simultaneously written
Windows 7 Pro, x64bit
By: ilharco on Tue, 29 March 2011
8 4542 Tue, 29 March 2011 17:06
By: BlackSwan
  nested select / instead-of-trigger and views=no index used
10g 10.2.0.4
By: Kevin Meade on Tue, 08 September 2009
10 4492 Tue, 29 March 2011 08:47
By: ipynnonen
  Performance issue with long running query
Oracle 11i
By: prasadpsk on Wed, 23 March 2011
14 6197 Tue, 29 March 2011 03:16
By: rleishman
  How to assure partition table is better than non-partition table (2 MERGED)
Oracle 10g R2
By: Tlg13team on Fri, 25 March 2011
11 3952 Mon, 28 March 2011 21:19
By: BlackSwan
  row cache lock/dc_users??
oracle 11g solaris 10
By: chris32680 on Thu, 17 March 2011
21 23633 Mon, 28 March 2011 09:03
By: Michel Cadot
icon5.gif clarification of query EXPLAIN plan
Oracle 10G, Solaris 10
By: Tlg13team on Thu, 24 March 2011
5 3473 Sun, 27 March 2011 20:15
By: Tlg13team
  why db need kill session instantly
Oracle 10G2, RedHat Linux Enterprice6
By: runinwind on Tue, 22 March 2011
2 2041 Sat, 26 March 2011 00:58
By: vjeedigunta
  sql library miss rate (2 Merged)
oracle database 10.2.0.4
By: karioookey on Fri, 18 March 2011
15 8762 Tue, 22 March 2011 14:29
By: Michel Cadot
  SQL Tuning ...
Oracle 11g R2
By: aucrun on Tue, 22 March 2011
1 1878 Tue, 22 March 2011 13:02
By: BlackSwan
icon8.gif 9582.69043 gigabytes of physical read total bytes and increasing!
11gR2 on Linux RedHat
By: nabeelkhan on Thu, 17 March 2011
8 6208 Sat, 19 March 2011 03:12
By: John Watson
  INDEXES on TIMESTAMP
Oracle 11.2 WIndows Vista 64bit
By: amcghie on Thu, 17 March 2011
0 12512 Thu, 17 March 2011 12:01
By: amcghie
  help me tune this
11g
By: xpact83 on Sun, 13 March 2011
3 2523 Mon, 14 March 2011 04:55
By: michael_bialik
  Update in a Loop
Oracle 11g
By: feroze on Fri, 11 March 2011
4 4559 Fri, 11 March 2011 12:08
By: flyboy
  help me tune this
oracle 11g
By: newbie69 on Fri, 11 March 2011
2 2498 Fri, 11 March 2011 04:30
By: Roachcoach
  query issue
oracle 10g
By: prashant_ora on Wed, 02 March 2011
24 3751 Thu, 10 March 2011 21:15
By: Flyby
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 Mar 29 06:11:09 CDT 2024