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 21647 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 1883 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 1054 Fri, 06 May 2011 07:22
By: John Watson
  Elapsed time
oracle 10g
By: fowjil on Thu, 05 May 2011
2 598 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 985 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 611 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 2385 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 1412 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 969 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 19168 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 1071 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 1505 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 1813 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 1910 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 862 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 1077 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 3105 Thu, 14 April 2011 09:09
By: S.Rajaram
  subquery optimization (6 threads merged by bb)
By: dave987 on Wed, 30 March 2011
12 2413 Wed, 13 April 2011 12:32
By: Barbara Boehmer
  Tuning Insert
10.1.0.5.0
By: sunny17 on Tue, 12 April 2011
4 910 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 692 Mon, 11 April 2011 15:01
By: ramoradba
  Hier - Query Perfomance (3 Merged)
By: mnafehm on Mon, 04 April 2011
3 969 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 1796 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 1095 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 2485 Wed, 06 April 2011 08:29
By: cookiemonster
  Performance tuning of query with self join
By: preethavinay on Wed, 06 April 2011
2 657 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 1035 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 2062 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 819 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 2858 Mon, 04 April 2011 06:35
By: John Watson
  Query not executing (3 Merged)
Oracle 10g
By: ajaykumarkona on Mon, 28 March 2011
11 1021 Mon, 04 April 2011 02:26
By: cookiemonster
  derived column index
oralce 10g
By: miroconnect@yahoo.com on Sat, 02 April 2011
3 837 Sat, 02 April 2011 08:37
By: BlackSwan
  using between slows query
oralce 10g
By: miroconnect@yahoo.com on Sat, 02 April 2011
1 1035 Sat, 02 April 2011 01:24
By: Michel Cadot
  Performance tuning of query with self join
By: preethavinay on Thu, 31 March 2011
6 1275 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 1613 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 1525 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 1488 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 2327 Tue, 29 March 2011 08:47
By: ipynnonen
  Performance issue with long running query
Oracle 11i
By: prasadpsk on Wed, 23 March 2011
14 1958 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 1391 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 10432 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: Sat Nov 22 23:10:15 CST 2014

Total time taken to generate the page: 0.11202 seconds