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

    Replies Views Last message
  Auto Stats gathering not including my schema?
oracle 11g solaris 10
By: chris32680 on Mon, 16 May 2011
16 16497 Fri, 20 May 2011 07:09
By: chris32680
  Query tuning
Oracle ,10.2.0.2.0,Unix ( 1 2)
By: Database admin on Wed, 18 May 2011
47 4304 Thu, 19 May 2011 05:57
By: Michel Cadot
  Multiple SELECT statement help
TOAD 9
By: gitarooman83 on Fri, 08 April 2011
6 2187 Mon, 16 May 2011 14:12
By: Barbara Boehmer
  Question regarding performance impact on disabling foreign key
ORACLE 10.2.0.3
By: Its_me_ved on Wed, 11 May 2011
8 2761 Fri, 13 May 2011 15:11
By: Michel Cadot
  No row resource operation information in tkprof output
Database 10.2.0.4
By: ole2009 on Fri, 13 May 2011
1 1745 Fri, 13 May 2011 14:26
By: BlackSwan
  Help in tuning a value set query
By: kavitayetakuri on Wed, 11 May 2011
20 9029 Fri, 13 May 2011 03:42
By: cookiemonster
  composite index
Oracle 11.1.0.7.0 64 bit
By: yassirrehman@gmail.com on Thu, 12 May 2011
1 1162 Thu, 12 May 2011 12:52
By: BlackSwan
icon7.gif Query Performance Issue
Oracle SQL Developer, v1.0.14.67
By: abdulrahaman288 on Wed, 11 May 2011
5 1475 Wed, 11 May 2011 07:18
By: Yasir Hashmi
  ORA-01555
Oracle 11gR2, Linux
By: gkrishn on Tue, 10 May 2011
10 15150 Tue, 10 May 2011 10:00
By: BlackSwan
  verify if procedure has been completed
Oracle 10.2.0.3, Jsp 2.0
By: Its_me_ved on Tue, 10 May 2011
2 1458 Tue, 10 May 2011 03:29
By: John Watson
  Table occupying max size
oracle 10.2.0.3, unix solaris
By: Its_me_ved on Mon, 09 May 2011
30 23486 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 3336 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 1936 Fri, 06 May 2011 07:22
By: John Watson
  Elapsed time
oracle 10g
By: fowjil on Thu, 05 May 2011
2 1092 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 1624 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 1145 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 6999 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 2726 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 2031 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 30057 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 1945 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 2454 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 2856 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 3199 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 1412 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 1771 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 6944 Thu, 14 April 2011 09:09
By: S.Rajaram
  subquery optimization (6 threads merged by bb)
By: dave987 on Wed, 30 March 2011
12 4157 Wed, 13 April 2011 12:32
By: Barbara Boehmer
  Tuning Insert
10.1.0.5.0
By: sunny17 on Tue, 12 April 2011
4 2545 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 1198 Mon, 11 April 2011 15:01
By: ramoradba
  Hier - Query Perfomance (3 Merged)
By: mnafehm on Mon, 04 April 2011
3 2265 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 3752 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 2223 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 4085 Wed, 06 April 2011 08:29
By: cookiemonster
  Performance tuning of query with self join
By: preethavinay on Wed, 06 April 2011
2 1192 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 3852 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 2738 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 1840 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 4841 Mon, 04 April 2011 06:35
By: John Watson
  Query not executing (3 Merged)
Oracle 10g
By: ajaykumarkona on Mon, 28 March 2011
11 2712 Mon, 04 April 2011 02:26
By: cookiemonster
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 Aug 05 19:54:42 CDT 2021