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

    Replies Views Last message
  Unable to avoid Indexes (2 Merged)
Oracle 10g, Windows 2000
By: oraranjangmailcom on Fri, 20 May 2011
28 1633 Thu, 26 May 2011 08:36
By: oraranjangmailcom
  How to Optimize the Query Without Using IN opertator
By: dhathri on Thu, 26 May 2011
2 731 Thu, 26 May 2011 07:01
By: Michel Cadot
  Tuning sub queries with function call
Oracle 11g
By: steve_mavros on Tue, 24 May 2011
6 1066 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 8919 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 1470 Thu, 19 May 2011 05:57
By: Michel Cadot
  Multiple SELECT statement help
TOAD 9
By: gitarooman83 on Fri, 08 April 2011
6 1145 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 1770 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 938 Fri, 13 May 2011 14:26
By: BlackSwan
  Help in tuning a value set query
By: kavitayetakuri on Wed, 11 May 2011
20 4865 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 624 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 710 Wed, 11 May 2011 07:18
By: Yasir Hashmi
  ORA-01555
Oracle 11gR2, Linux
By: gkrishn on Tue, 10 May 2011
10 13511 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 952 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 21657 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 1923 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 1079 Fri, 06 May 2011 07:22
By: John Watson
  Elapsed time
oracle 10g
By: fowjil on Thu, 05 May 2011
2 603 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 1002 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 622 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 2462 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 1445 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 1001 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 19395 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 1088 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 1521 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 1839 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 1950 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 880 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 1090 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 3195 Thu, 14 April 2011 09:09
By: S.Rajaram
  subquery optimization (6 threads merged by bb)
By: dave987 on Wed, 30 March 2011
12 2444 Wed, 13 April 2011 12:32
By: Barbara Boehmer
  Tuning Insert
10.1.0.5.0
By: sunny17 on Tue, 12 April 2011
4 942 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 704 Mon, 11 April 2011 15:01
By: ramoradba
  Hier - Query Perfomance (3 Merged)
By: mnafehm on Mon, 04 April 2011
3 991 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 1820 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 1123 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 2516 Wed, 06 April 2011 08:29
By: cookiemonster
  Performance tuning of query with self join
By: preethavinay on Wed, 06 April 2011
2 664 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 1053 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 2070 Wed, 06 April 2011 01:16
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: Mon Dec 29 06:29:06 CST 2014

Total time taken to generate the page: 0.22576 seconds