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

    Replies Views Last message
  Table occupying max size
oracle 10.2.0.3, unix solaris
By: Its_me_ved on Mon, 09 May 2011
30 21370 Tue, 10 May 2011 02:44
By: Michel Cadot
  Oracle Buffer Cache vs AIX Filesystem Cache
Oracle 10gR2 on AIX 6.1
By: eclipsis on Sat, 07 May 2011
4 1772 Sun, 08 May 2011 01:22
By: Michel Cadot
  After trigger causing performance bottleneck
Windows Xp, Oracle 10g
By: a_oracle on Fri, 06 May 2011
3 993 Fri, 06 May 2011 07:22
By: John Watson
  Elapsed time
oracle 10g
By: fowjil on Thu, 05 May 2011
2 586 Thu, 05 May 2011 09:47
By: Littlefoot
  Procedure code taking longer time to execute
Oracle 10.2.0.2.0 , Unix
By: Database admin on Wed, 04 May 2011
3 936 Wed, 04 May 2011 09:50
By: BlackSwan
  Adding +0 and -0 to a number predicate produces differents plans.
10.2.0.4
By: nikko on Fri, 29 April 2011
1 567 Fri, 29 April 2011 16:03
By: Kevin Meade
  What is causing the lock despite such an decent update state
Oracle 10gr2, windows 32
By: kytemanaic on Wed, 27 April 2011
2 2186 Fri, 29 April 2011 01:42
By: kytemanaic
  tkprof trace analyze for recommendataion
10.2.0.2.0
By: sudityakumargmailcom on Fri, 22 April 2011
6 1321 Wed, 27 April 2011 02:47
By: John Watson
  Sql tuning
Oracle 10.2.0.3
By: Its_me_ved on Thu, 21 April 2011
7 899 Wed, 27 April 2011 01:27
By: michael_bialik
  Only LOCAL bitmap indexes are permitted on partitioned tables
By: Sreedhar Reddy on Fri, 04 February 2005
3 18460 Tue, 26 April 2011 18:46
By: ankitamehani
  AWR
Oracle 10g 10.2.0.1.0/Windows 2003 Server
By: gxeon on Thu, 21 April 2011
6 1043 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 1444 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 1724 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 1811 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 814 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 1029 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 2893 Thu, 14 April 2011 09:09
By: S.Rajaram
  subquery optimization (6 threads merged by bb)
By: dave987 on Wed, 30 March 2011
12 2318 Wed, 13 April 2011 12:32
By: Barbara Boehmer
  Tuning Insert
10.1.0.5.0
By: sunny17 on Tue, 12 April 2011
4 833 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 672 Mon, 11 April 2011 15:01
By: ramoradba
  Hier - Query Perfomance (3 Merged)
By: mnafehm on Mon, 04 April 2011
3 913 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 1694 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 1030 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 2386 Wed, 06 April 2011 08:29
By: cookiemonster
  Performance tuning of query with self join
By: preethavinay on Wed, 06 April 2011
2 625 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 980 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 2026 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 741 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 2678 Mon, 04 April 2011 06:35
By: John Watson
  Query not executing (3 Merged)
Oracle 10g
By: ajaykumarkona on Mon, 28 March 2011
11 915 Mon, 04 April 2011 02:26
By: cookiemonster
  derived column index
oralce 10g
By: miroconnect@yahoo.com on Sat, 02 April 2011
3 781 Sat, 02 April 2011 08:37
By: BlackSwan
  using between slows query
oralce 10g
By: miroconnect@yahoo.com on Sat, 02 April 2011
1 1000 Sat, 02 April 2011 01:24
By: Michel Cadot
  Performance tuning of query with self join
By: preethavinay on Thu, 31 March 2011
6 1211 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 1507 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 1471 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 1378 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 2180 Tue, 29 March 2011 08:47
By: ipynnonen
  Performance issue with long running query
Oracle 11i
By: prasadpsk on Wed, 23 March 2011
14 1831 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 1283 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 9736 Mon, 28 March 2011 09:03
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 Jul 31 21:36:02 CDT 2014

Total time taken to generate the page: 0.11760 seconds