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

    Replies Views Last message
icon4.gif Performance Tuning in Oracle 10g during Migration - Heavy Insert Optimization
Oracle 10g
By: ajexpert on Tue, 15 April 2008
27 7104 Sun, 03 July 2011 23:27
By: Michel Cadot
  How to measure the sql run time?
Oracle 10.2.0.4.0 64bit , AIX 5.3
By: snowball on Sun, 26 June 2011
12 1909 Sun, 03 July 2011 16:11
By: LNossov
  SQL tuning
By: hannah00 on Thu, 09 June 2011
22 1421 Sat, 02 July 2011 01:25
By: Kevin Meade
  Performance Standard Edition without partitioning
Oracle 11g - RHEL 5
By: pbaldanta on Thu, 16 June 2011
2 630 Sat, 02 July 2011 01:05
By: Kevin Meade
  Oracle hash join
Oracle 9i
By: dushan_st on Thu, 23 June 2011
21 18534 Sat, 02 July 2011 00:26
By: Kevin Meade
  AWR Report network foreground wait events
11.1.0.7.0, Linux
By: kavitagoel00 on Wed, 29 June 2011
8 4195 Thu, 30 June 2011 17:15
By: BlackSwan
  Performance Issue
Oracle 10g, Windows XP
By: a_oracle on Wed, 29 June 2011
1 470 Wed, 29 June 2011 12:50
By: BlackSwan
  Local Index vs Global Index on partitioned table
Oracle 10g
By: mandeepmandy on Tue, 28 June 2011
6 2943 Wed, 29 June 2011 02:12
By: hkchital
icon14.gif how to show the right I\O of query
By: assa9009 on Tue, 21 June 2011
2 633 Mon, 27 June 2011 22:48
By: BlackSwan
  Setting flash cache initialisation parameters
11g/r2 (OEL 5.5 running patch 9654983)
By: dsub42 on Wed, 11 August 2010
6 3583 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 595 Thu, 23 June 2011 04:27
By: John Watson
  Big Table data Maintenance
Oracle 10G
By: saswatic on Fri, 17 June 2011
3 961 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 1039 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 564 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 1179 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 1181 Tue, 14 June 2011 06:22
By: orsoghu
  Database Performance is very slow
oracle 10g
By: adnanmkm on Tue, 14 June 2011
2 939 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 1454 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 1502 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 806 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 1247 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 5126 Thu, 02 June 2011 11:05
By: getzeeshan
  Advice on Index Creation
Windows 2000, Oracle 10g
By: oraranjangmailcom on Wed, 01 June 2011
11 570 Thu, 02 June 2011 08:56
By: BlackSwan
  Slow query with distinct
Oracle 10G
By: uicmxz on Tue, 31 May 2011
8 1994 Wed, 01 June 2011 10:27
By: BlackSwan
  index advises
By: hannah00 on Mon, 23 May 2011
20 790 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 1163 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 1481 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 681 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 1004 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 8241 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 1373 Thu, 19 May 2011 05:57
By: Michel Cadot
  Multiple SELECT statement help
TOAD 9
By: gitarooman83 on Fri, 08 April 2011
6 1075 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 1668 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 896 Fri, 13 May 2011 14:26
By: BlackSwan
  Help in tuning a value set query
By: kavitayetakuri on Wed, 11 May 2011
20 4619 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 583 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 653 Wed, 11 May 2011 07:18
By: Yasir Hashmi
  ORA-01555
Oracle 11gR2, Linux
By: gkrishn on Tue, 10 May 2011
10 13308 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 915 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 21103 Tue, 10 May 2011 02:44
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: Tue Jul 29 11:25:30 CDT 2014

Total time taken to generate the page: 0.27196 seconds