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

    Replies Views Last message
  Update statement query tuning
9i
By: shiva_jm on Mon, 21 December 2009
7 3248 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 15023 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 2679 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 2147 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 2836 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 5127 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 2510 Thu, 17 December 2009 10:53
By: BlackSwan
  select clause
10g
By: kish_ulike on Thu, 17 December 2009
2 1912 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 3604 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 1682 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 2009 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 3360 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 3891 Thu, 10 December 2009 05:58
By: JRowbottom
  Index Partitioning local or global or both??
By: nsingh49 on Thu, 19 November 2009
9 3484 Wed, 09 December 2009 06:00
By: rleishman
  Need to tune a Query - xjd
By: marlon_loyolite on Thu, 03 December 2009
6 3413 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 1624 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 4897 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 4349 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 8170 Mon, 07 December 2009 09:26
By: JRowbottom
  retrieve deleted data of user_jobs
Oracle 10g,
By: spur230 on Sat, 07 November 2009
19 9970 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 3672 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 9643 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 9969 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 2903 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 4479 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 3138 Tue, 01 December 2009 08:56
By: chetanaZ
  After Version Enabled (Workspace Manager)
Oracle 10g
By: rakeshramm on Wed, 25 November 2009
2 2303 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 2625 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 8147 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 5001 Mon, 23 November 2009 01:10
By: michael_bialik
  how to enable trace for other sessions?
By: priyasinha396 on Mon, 16 November 2009
7 7123 Fri, 20 November 2009 04:47
By: trantuananh24hg
  query delay
10.2.0.3, Windows 2003
By: newsurfgal on Tue, 17 November 2009
4 2653 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 10691 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 3361 Mon, 16 November 2009 23:11
By: Michel Cadot
  .trc files
By: priyasinha396 on Mon, 16 November 2009
2 1721 Mon, 16 November 2009 01:09
By: priyasinha396
  Does CTAS uses unused space??
By: sameertuladhar on Thu, 12 November 2009
4 2276 Fri, 13 November 2009 17:18
By: rleishman
  User statistics
Oracle 10.2.0.4
By: gkrishn on Mon, 09 November 2009
3 2799 Mon, 09 November 2009 07:07
By: Michel Cadot
  to check for temporary space usage
10.2.0.4
By: ankush_chawla on Wed, 04 November 2009
9 4936 Mon, 09 November 2009 06:35
By: ramoradba
  Oracle 10.2.0.4
IBM AIX 5.3
By: ravi214u on Thu, 05 November 2009
9 7792 Sat, 07 November 2009 10:09
By: BlackSwan
  SQL Tune
Oracle 10g Database 10.2.0.4 + Oracle Client 9.2.0.1
By: babuknb on Fri, 06 November 2009
7 3677 Fri, 06 November 2009 08:16
By: babuknb
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: Sat May 04 08:02:26 CDT 2024