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

    Replies Views Last message
  How to retrieve SQLs and execution plans from awr history
oracle database 10R2
By: anurag_telenor on Wed, 23 December 2009
3 15890 Wed, 23 December 2009 18:00
By: BlackSwan
  Deadlock interpretation
Oracle 10g
By: vipull.sayal on Wed, 23 December 2009
2 3247 Wed, 23 December 2009 15:59
By: vipull.sayal
  oracle instance performance
oralce 9i , Linux
By: chuikingman on Tue, 22 December 2009
1 2213 Tue, 22 December 2009 05:15
By: Michel Cadot
  Update statement query tuning
9i
By: shiva_jm on Mon, 21 December 2009
7 3846 Tue, 22 December 2009 01:49
By: rleishman
  Memory Notification: Library Cache Object loaded into SGA
oracle 10g
By: gir_sat on Mon, 21 December 2009
2 16215 Mon, 21 December 2009 08:02
By: Michel Cadot
  Problem in understanding the autotrace output exectution plan and statistics
10.2.0.4, RHEL4
By: spabolu on Thu, 17 December 2009
3 3184 Sun, 20 December 2009 20:52
By: rleishman
  How to configure Oracle on Two Servers in Hot Redundant mode
Oracle 10g on Windows Server 2003
By: myinvention99 on Thu, 17 December 2009
1 2765 Fri, 18 December 2009 09:09
By: LKBrwn_DBA
  sql tuning help
oracle 10g,1,xp
By: krajasekhar.v on Fri, 18 December 2009
8 3498 Fri, 18 December 2009 05:39
By: _jum
icon4.gif Why Oracle 10g slows down Copmuter after few days
Oracle 10g 10.2.0.1.0
By: myinvention99 on Sat, 21 November 2009
12 6036 Thu, 17 December 2009 15:34
By: myinvention99
  Queries in oracle indexing
oracle, 10.1.0.5.0, sun solaris
By: sathik on Thu, 17 December 2009
4 3061 Thu, 17 December 2009 10:53
By: BlackSwan
  select clause
10g
By: kish_ulike on Thu, 17 December 2009
2 2543 Thu, 17 December 2009 00:34
By: pablolee
icon4.gif grants running extemely slow
Oracle 10.2.0.3 on Linux
By: king303 on Tue, 15 December 2009
9 4229 Wed, 16 December 2009 02:55
By: king303
  Cost of a Rollback
Oracle 10.2.0.4, Windows 2003 server
By: Arokh on Fri, 11 December 2009
3 2232 Fri, 11 December 2009 13:48
By: Arokh
  Query to be restructured for performance gain
Oracle 10G
By: bholeuday on Fri, 11 December 2009
2 2435 Fri, 11 December 2009 10:50
By: BlackSwan
  APPEND hint in Rule and Cost based optimizer
oracle 10g
By: ganesh104 on Thu, 10 December 2009
5 3997 Thu, 10 December 2009 19:35
By: rleishman
  require to tune a sql query
oracle,10.1.0.4.0,Sun solaris 5.10
By: sathik on Wed, 09 December 2009
10 4609 Thu, 10 December 2009 05:58
By: JRowbottom
  Index Partitioning local or global or both??
By: nsingh49 on Thu, 19 November 2009
9 4185 Wed, 09 December 2009 06:00
By: rleishman
  Need to tune a Query - xjd
By: marlon_loyolite on Thu, 03 December 2009
6 4042 Wed, 09 December 2009 00:53
By: michael_bialik
icon5.gif Unindexing foreign key
Oracle 10.2G
By: wakula on Tue, 08 December 2009
1 2083 Tue, 08 December 2009 06:37
By: JRowbottom
icon5.gif Horizontal vs Vertical data table design
Oracle 10.2G
By: wakula on Mon, 30 November 2009
6 5615 Tue, 08 December 2009 02:41
By: JRowbottom
  Buffer pool Hit% more than 100%
oracle 10g, 10.2, soalaris
By: DBA_SangramKeshari on Mon, 16 November 2009
13 5234 Tue, 08 December 2009 02:20
By: JRowbottom
  Performance issue while pl/sql script execution (merged 3)
oracle 10.2.0.4 , Solaris sparc
By: lalitm_2003 on Wed, 02 December 2009
19 9199 Mon, 07 December 2009 09:26
By: JRowbottom
  retrieve deleted data of user_jobs
Oracle 10g,
By: spur230 on Sat, 07 November 2009
19 11402 Mon, 07 December 2009 08:32
By: JRowbottom
  can we write below query in a better way
oracle10g
By: chaituu on Fri, 04 December 2009
10 4420 Mon, 07 December 2009 02:52
By: michael_bialik
  How to calculate ideal size of log_buffer parameter?
10.2.0.4, sun spark 64 bit
By: halim on Thu, 19 November 2009
10 10636 Mon, 07 December 2009 00:47
By: DBA_SangramKeshari
  SQL via Crystal Reports and ODBC is very slow, same SQL with toad is fast
Oracle Database 10g Enterprise Edition 10.2.0.1.0
By: thomas.weigel on Thu, 03 December 2009
6 10735 Thu, 03 December 2009 21:31
By: wvu1999
  How to identify table need resequencing.
10.2.0.3.0 on xp
By: misragopal on Thu, 03 December 2009
4 4030 Thu, 03 December 2009 06:07
By: JRowbottom
  DBMS_OUTLINE to override HINTS [Merged]
Oracle Database 10g Enterprise Edition Release 10.2.0.3.0 - 64bi
By: spur230 on Fri, 20 November 2009
3 5036 Wed, 02 December 2009 07:20
By: LKBrwn_DBA
  Nologging Feature in Archivelog mode : strange Results
Oracle 9.2.0.6.0 on HP-UX
By: chetanaZ on Mon, 30 November 2009
5 3685 Tue, 01 December 2009 08:56
By: chetanaZ
  After Version Enabled (Workspace Manager)
Oracle 10g
By: rakeshramm on Wed, 25 November 2009
2 2821 Fri, 27 November 2009 00:38
By: Kevin Meade
  Very high executions (Parse=Execute)
Oracle 10g, Solaris 10
By: trantuananh24hg on Thu, 26 November 2009
2 3096 Fri, 27 November 2009 00:37
By: trantuananh24hg
  Performance of a Query
11.5.10, 10g Database
By: garylythgoe on Mon, 16 November 2009
22 9721 Mon, 23 November 2009 10:09
By: S.Rajaram
icon8.gif How to tune a update statement
Oracle 10g, Solaris 10
By: lucas4394 on Thu, 19 November 2009
9 5838 Mon, 23 November 2009 01:10
By: michael_bialik
  how to enable trace for other sessions?
By: priyasinha396 on Mon, 16 November 2009
7 7976 Fri, 20 November 2009 04:47
By: trantuananh24hg
  query delay
10.2.0.3, Windows 2003
By: newsurfgal on Tue, 17 November 2009
4 3200 Wed, 18 November 2009 22:20
By: Kevin Meade
  ORA-00060 Deadlock issue with trigger
10.2.0.4.0, Linux
By: KaushalPanjwani on Wed, 09 September 2009
9 11600 Tue, 17 November 2009 09:52
By: BlackSwan
  Profile Limits
10.2.0.4.0 - IBM AIX
By: user7509 on Mon, 16 November 2009
1 3877 Mon, 16 November 2009 23:11
By: Michel Cadot
  .trc files
By: priyasinha396 on Mon, 16 November 2009
2 2330 Mon, 16 November 2009 01:09
By: priyasinha396
  Does CTAS uses unused space??
By: sameertuladhar on Thu, 12 November 2009
4 2978 Fri, 13 November 2009 17:18
By: rleishman
  User statistics
Oracle 10.2.0.4
By: gkrishn on Mon, 09 November 2009
3 3322 Mon, 09 November 2009 07:07
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: Thu Jul 10 00:44:04 CDT 2025