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

    Replies Views Last message
  Tuning sub queries with function call
Oracle 11g
By: steve_mavros on Tue, 24 May 2011
6 1022 Tue, 24 May 2011 10:25
By: Michel Cadot
  Auto Stats gathering not including my schema?
oracle 11g solaris 10
By: chris32680 on Mon, 16 May 2011
16 8398 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 1392 Thu, 19 May 2011 05:57
By: Michel Cadot
  Multiple SELECT statement help
TOAD 9
By: gitarooman83 on Fri, 08 April 2011
6 1096 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 1694 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 900 Fri, 13 May 2011 14:26
By: BlackSwan
  Help in tuning a value set query
By: kavitayetakuri on Wed, 11 May 2011
20 4658 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 599 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 663 Wed, 11 May 2011 07:18
By: Yasir Hashmi
  ORA-01555
Oracle 11gR2, Linux
By: gkrishn on Tue, 10 May 2011
10 13338 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 923 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 21600 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 1805 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 1011 Fri, 06 May 2011 07:22
By: John Watson
  Elapsed time
oracle 10g
By: fowjil on Thu, 05 May 2011
2 589 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 957 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 582 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 2256 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 1352 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 917 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 18644 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 1051 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 1462 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 1753 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 1836 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 825 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 1041 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 2946 Thu, 14 April 2011 09:09
By: S.Rajaram
  subquery optimization (6 threads merged by bb)
By: dave987 on Wed, 30 March 2011
12 2341 Wed, 13 April 2011 12:32
By: Barbara Boehmer
  Tuning Insert
10.1.0.5.0
By: sunny17 on Tue, 12 April 2011
4 860 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 673 Mon, 11 April 2011 15:01
By: ramoradba
  Hier - Query Perfomance (3 Merged)
By: mnafehm on Mon, 04 April 2011
3 934 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 1713 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 1042 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 2403 Wed, 06 April 2011 08:29
By: cookiemonster
  Performance tuning of query with self join
By: preethavinay on Wed, 06 April 2011
2 632 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 991 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 2039 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 761 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 2735 Mon, 04 April 2011 06:35
By: John Watson
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: Mon Sep 01 07:27:25 CDT 2014

Total time taken to generate the page: 0.09557 seconds