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

    Replies Views Last message
  Setting flash cache initialisation parameters
11g/r2 (OEL 5.5 running patch 9654983)
By: dsub42 on Wed, 11 August 2010
6 6081 Mon, 27 June 2011 16:05
By: Gollum
  Which index should use ??
Oracle 10g, windows 2003 Server
By: pradies on Thu, 23 June 2011
10 2541 Thu, 23 June 2011 04:27
By: John Watson
  Big Table data Maintenance
Oracle 10G
By: saswatic on Fri, 17 June 2011
3 2219 Tue, 21 June 2011 07:25
By: tahpush
  statistics collection
Oracle 10.2.0.3
By: Its_me_ved on Fri, 17 June 2011
2 2145 Sun, 19 June 2011 21:58
By: hkchital
  Tuning option selection (merged 2)
WIndows XP, Oracle 10g
By: a_oracle on Thu, 09 June 2011
2 1699 Tue, 14 June 2011 08:17
By: michael_bialik
  Oracle data migration performance issues
10.2.0.3
By: shashikantkale on Tue, 07 June 2011
6 3234 Tue, 14 June 2011 07:51
By: michael_bialik
  merging 2 big tables
Oracle Database 10g Enterprise Edition Release 10.2.0.4.0 - 64bit Production, linux
By: orsoghu on Tue, 14 June 2011
4 2768 Tue, 14 June 2011 06:22
By: orsoghu
  Database Performance is very slow
oracle 10g
By: adnanmkm on Tue, 14 June 2011
2 1857 Tue, 14 June 2011 06:17
By: cookiemonster
  Delete statement being running for over 2hrs
Oracle 11.2.0.1, Red Hat Linux 2.6.18-128.el5 x86_64
By: youngb912 on Fri, 03 June 2011
16 4965 Mon, 06 June 2011 22:31
By: BlackSwan
  Speed Up the gathering of stats.
Windows XP, Oracle 10g
By: oraranjangmailcom on Thu, 02 June 2011
12 5765 Mon, 06 June 2011 21:37
By: hkchital
  Tuning Select Not IN statement(2 Merged)
10g R2
By: getzeeshan on Thu, 02 June 2011
15 3207 Fri, 03 June 2011 17:59
By: getzeeshan
  Solution Required for Sql Performance issue in oracle due to Null value check(2 Merged)
Oracle 10gR2
By: ganeshkn21 on Wed, 01 June 2011
27 5308 Fri, 03 June 2011 09:47
By: BlackSwan
  Tuning Merge Statetment
Oracle 10.2.0.4 Enterprise Edition
By: getzeeshan on Wed, 18 May 2011
28 9148 Thu, 02 June 2011 11:05
By: getzeeshan
  Advice on Index Creation
Windows 2000, Oracle 10g
By: oraranjangmailcom on Wed, 01 June 2011
11 2545 Thu, 02 June 2011 08:56
By: BlackSwan
  Slow query with distinct
Oracle 10G
By: uicmxz on Tue, 31 May 2011
8 4252 Wed, 01 June 2011 10:27
By: BlackSwan
  index advises
By: hannah00 on Mon, 23 May 2011
20 4164 Fri, 27 May 2011 10:37
By: Kevin Meade
  Statistics gathering approach
Oracle 10.2.0.3
By: Its_me_ved on Fri, 27 May 2011
4 2439 Fri, 27 May 2011 02:20
By: Michel Cadot
  Unable to avoid Indexes (2 Merged)
Oracle 10g, Windows 2000
By: oraranjangmailcom on Fri, 20 May 2011
28 5322 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 1904 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 2481 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 17209 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 5281 Thu, 19 May 2011 05:57
By: Michel Cadot
  Multiple SELECT statement help
TOAD 9
By: gitarooman83 on Fri, 08 April 2011
6 2782 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 3678 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 2237 Fri, 13 May 2011 14:26
By: BlackSwan
  Help in tuning a value set query
By: kavitayetakuri on Wed, 11 May 2011
20 10912 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 1624 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 2139 Wed, 11 May 2011 07:18
By: Yasir Hashmi
  ORA-01555
Oracle 11gR2, Linux
By: gkrishn on Tue, 10 May 2011
10 15848 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 1993 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 24295 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 4111 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 2419 Fri, 06 May 2011 07:22
By: John Watson
  Elapsed time
oracle 10g
By: fowjil on Thu, 05 May 2011
2 1502 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 2072 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 1532 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 8038 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 3313 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 2818 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 32715 Tue, 26 April 2011 18:46
By: ankitamehani
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: Fri Feb 23 13:26:35 CST 2024