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

    Replies Views Last message
  Index Hit Retio
Oracle Database 11g Enterprise Edition Release 11.1.0.7.0 - 64bit Production
By: rahulvb on Thu, 25 March 2010
8 2884 Fri, 26 March 2010 15:10
By: BlackSwan
  Swap Partition or Recreate Synonym
10g
By: beetel on Tue, 23 March 2010
3 3520 Tue, 23 March 2010 05:06
By: cookiemonster
  most accessed
11g, solaris 9
By: orafacjublu on Mon, 08 March 2010
4 2565 Tue, 23 March 2010 04:27
By: michael_bialik
  11g sql tuning(urgent)
11g,solaris9
By: orafacjublu on Wed, 10 March 2010
2 2875 Sat, 20 March 2010 09:54
By: Kevin Meade
  Optimize the Query
Oracle 9i
By: virmahi on Fri, 19 March 2010
2 3290 Fri, 19 March 2010 08:30
By: Kevin Meade
  Slow connection in Linux 64 bit oracle 9i
Oracle 9.2.0.6, Linux 64 bit
By: naren.sarkar on Sat, 13 March 2010
19 16030 Thu, 18 March 2010 11:25
By: BlackSwan
  11g index can't be rebuild
11g, solaris 9
By: orafacjublu on Thu, 18 March 2010
3 8914 Thu, 18 March 2010 05:25
By: Michel Cadot
  Lot of Trace files under udump,bdump with error: Ioctl ASYNC_CONFIG error, errno = 1
Oracle 10.2.0.4 on HP-UX
By: Ricky_1362002 on Wed, 10 March 2010
8 18661 Thu, 11 March 2010 11:51
By: Ricky_1362002
  Update statement resulting time out
Oracle 10g
By: virmahi on Thu, 04 March 2010
37 8276 Wed, 10 March 2010 04:24
By: cookiemonster
  Explicit cursor data
Oracle10g
By: shrinika on Tue, 09 March 2010
3 1996 Tue, 09 March 2010 23:01
By: Michel Cadot
  sga
11g,solaris 9
By: orafacjublu on Tue, 09 March 2010
1 1690 Tue, 09 March 2010 05:56
By: Michel Cadot
  Tune "where col in (val1,val2,val3)
oracle 10g
By: harshalonline22 on Tue, 09 March 2010
2 2057 Tue, 09 March 2010 04:31
By: Michel Cadot
  Resource busy during stats gather
Oracle 10g
By: gkrishn on Sun, 07 March 2010
2 2805 Sun, 07 March 2010 08:48
By: gkrishn
  Autotrace (merged by CM)
Oracle 9.2, Windows
By: visuorac on Wed, 03 March 2010
2 1960 Wed, 03 March 2010 06:43
By: Michel Cadot
  Can this query be improved for performance?
By: ziggy25 on Tue, 02 March 2010
9 2931 Tue, 02 March 2010 08:32
By: Michel Cadot
  Should an index be rebuilt or recreated during data load.
By: ziggy25 on Tue, 02 March 2010
1 1698 Tue, 02 March 2010 04:24
By: Michel Cadot
  TEMP TABLESPACE
11G, WINDOWS
By: orafacjublu on Tue, 02 March 2010
1 2718 Tue, 02 March 2010 00:25
By: Michel Cadot
  ora-1652
11g,solaris 9
By: orafacjublu on Mon, 01 March 2010
9 7143 Tue, 02 March 2010 00:02
By: orafacjublu
  question about stats
oracle 10.2.0.4 on solaris 8
By: orausern on Mon, 01 March 2010
5 3021 Mon, 01 March 2010 10:11
By: orausern
  Performance regression from 8i to 10G
Oracle 10G
By: Irena on Thu, 25 February 2010
2 2165 Mon, 01 March 2010 01:53
By: michael_bialik
  Restructering
Oracle, 10g, Windows server 2003
By: getritesh on Thu, 18 February 2010
5 3945 Fri, 26 February 2010 04:31
By: JRowbottom
icon14.gif ORACLE OPTIMIZER
Oracle 9.2, Windows
By: visuorac on Tue, 23 February 2010
1 2013 Tue, 23 February 2010 22:14
By: BlackSwan
  Migration to Oracle 10 Performance issues
Oracle 10g Database
By: gmakinana on Mon, 22 February 2010
2 1771 Tue, 23 February 2010 21:12
By: rahulvb
icon11.gif Query Tuning
Oracle 9.2, Windows
By: visuorac on Wed, 17 February 2010
10 4263 Mon, 22 February 2010 10:15
By: cookiemonster
  Improve Performance (Merged RL)
Oracle, 10g, Windows server 2003
By: getritesh on Sat, 20 February 2010
9 3428 Sun, 21 February 2010 09:56
By: Michel Cadot
  Copy history from db1 to db 2
oracle 10, unix
By: elnbado on Fri, 19 February 2010
1 1991 Fri, 19 February 2010 05:42
By: ramoradba
  11g Result Cache
oracle11g, unix
By: orafacjublu on Wed, 17 February 2010
7 4575 Fri, 19 February 2010 02:10
By: tahpush
icon6.gif Raplace Group by clause
Oracle 9.2, Windows
By: visuorac on Thu, 18 February 2010
4 3047 Thu, 18 February 2010 04:03
By: Michel Cadot
  Pls tell me, what I need to check before tuning the SQL code?
Windows
By: victoryhendry on Wed, 17 February 2010
1 1636 Wed, 17 February 2010 08:36
By: Michel Cadot
  Can some review my materialized view?
Oracle 9i
By: pdaalder on Wed, 17 February 2010
1 2367 Wed, 17 February 2010 07:19
By: S.Rajaram
icon14.gif Replace Not Exists
Oracle 9.2, UNIX
By: visuorac on Wed, 17 February 2010
4 3768 Wed, 17 February 2010 06:42
By: S.Rajaram
  Tuning Distributed Queries
oracle 11g with windows server2003 64bit
By: Adeelusman on Tue, 16 February 2010
4 3185 Tue, 16 February 2010 23:25
By: Adeelusman
  High enqueue waits in statspack - lock contention on Primary key index showing 98% of db wait time
9.2.0.6
By: mwansa on Thu, 11 February 2010
22 9924 Mon, 15 February 2010 11:58
By: S.Rajaram
  Performance Pruning on fact table
10.2.0.4
By: summoner on Wed, 10 February 2010
10 4999 Fri, 12 February 2010 07:48
By: Kevin Meade
  Index is not used after running dbms_stats.gather_table_stats
Oracle Database 10g in Sun Solaris 64bit
By: katripon on Sat, 06 February 2010
7 5968 Tue, 09 February 2010 07:51
By: raselvista
  Long run time of query with Order by clause
Oracle 10g
By: ganesh104 on Fri, 05 February 2010
3 3052 Fri, 05 February 2010 15:06
By: BlackSwan
icon8.gif HASH cluster building very Slow
Oracle 10g R2
By: sky_lt on Tue, 02 February 2010
7 4378 Fri, 05 February 2010 03:05
By: John Watson
  Performance issue in Oracle 10g using Bulk Collect
Oracle 10.2.0.3.0
By: venkat_bollu on Fri, 05 February 2010
3 3973 Fri, 05 February 2010 02:58
By: Michel Cadot
  Function Based Indexes
By: navin_deep on Wed, 03 February 2010
2 2404 Wed, 03 February 2010 12:09
By: Michel Cadot
  Oracle Segment Tuning
Oracle10g
By: salora on Tue, 02 February 2010
2 8582 Tue, 02 February 2010 02:59
By: rahulvb
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: Sun Jun 23 18:17:59 CDT 2024