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

    Replies Views Last message
  Is it Oracle 10g slower comparatively Oracle 9i
By: sponguru on Fri, 07 April 2006
1 990 Fri, 07 April 2006 03:50
By: madhusunkara
  slow connection to oracle 8 server with oracle 9 client
By: mustafat on Thu, 30 March 2006
1 1249 Wed, 05 April 2006 07:21
By: mustafat
  "db file scattered read" too high and Query going for full table scan-Why ?
By: tayalarun on Tue, 04 April 2006
4 1737 Tue, 04 April 2006 18:11
By: RaeMarvin
  gather_fixed_objects_stats
By: orant1 on Mon, 03 April 2006
1 3640 Mon, 03 April 2006 06:36
By: Mahesh Rajendran
  Clearing Blocks from Memory
By: scottwmackey on Fri, 31 March 2006
4 1760 Mon, 03 April 2006 04:43
By: madhusunkara
  Query Speed Slow.
By: rvnair123 on Fri, 31 March 2006
3 1480 Mon, 03 April 2006 03:22
By: nmacdannald
  Merge Cartesian Join in Plan and More Reads
By: faiz_hyd on Fri, 31 March 2006
1 1098 Fri, 31 March 2006 22:49
By: rleishman
  generic SGA
By: oxalide on Mon, 27 March 2006
1 1036 Fri, 31 March 2006 05:59
By: Frank Naude
  Use of 1 Cpu insted of 2 on Oracle 10 G
By: luchot on Tue, 28 March 2006
2 786 Fri, 31 March 2006 02:30
By: luchot
  Can anyone do the guidance to learn Performance Tuning?
By: srivishnuhari on Thu, 30 March 2006
2 1123 Fri, 31 March 2006 01:22
By: rleishman
  resolving buffer busy waits
By: tridentadm on Sun, 26 March 2006
2 1380 Fri, 31 March 2006 00:43
By: madhusunkara
  How I can Eliminate the Full Table scan for the following query?
By: srivishnuhari on Thu, 30 March 2006
1 948 Fri, 31 March 2006 00:37
By: madhusunkara
icon5.gif Partition & Performance
By: lucas4394 on Sat, 25 March 2006
6 1710 Thu, 30 March 2006 21:32
By: rleishman
  Balanced Decision on Index Creation
By: faiz_hyd on Mon, 27 March 2006
11 2320 Wed, 29 March 2006 04:11
By: JSI2001
  Question about PERFSTAT Tablespace
By: Uwe on Wed, 29 March 2006
3 2802 Wed, 29 March 2006 03:15
By: Frank
  oracle solaris tuning kernel
By: khaledfarid on Wed, 22 March 2006
3 2488 Wed, 29 March 2006 00:07
By: madhusunkara
  Global and Local Index
By: toshidas2000 on Mon, 27 March 2006
1 987 Mon, 27 March 2006 22:17
By: rleishman
  Materialized View Based on a Union Query
By: kishorekumar_1982 on Mon, 27 March 2006
1 1242 Mon, 27 March 2006 22:14
By: rleishman
  Different Plan for Inner and Outer Query
By: feroze on Wed, 22 March 2006
5 1556 Mon, 27 March 2006 00:16
By: rleishman
  information about indexes
By: kinjal on Thu, 23 March 2006
7 2301 Sun, 26 March 2006 22:33
By: tarundua
  How increase SGA more than 25% of physical memory
By: enkhbold on Fri, 24 March 2006
1 955 Sun, 26 March 2006 16:16
By: BlackSwan
  SQLTRACE AND DB_FILE_SEQUENTIAL_READ
By: sumang24 on Wed, 22 March 2006
9 5441 Sat, 25 March 2006 08:56
By: Mahesh Rajendran
  Function taking very long to execute
By: alfatat on Sat, 25 March 2006
1 838 Sat, 25 March 2006 05:37
By: Frank
  help!!->resolving "cpu time" problem
By: rzmni on Wed, 08 March 2006
1 970 Sat, 25 March 2006 01:03
By: Frank Naude
  where is UGA stored ??
By: tridentadm on Thu, 23 March 2006
1 824 Fri, 24 March 2006 06:02
By: amit_nanote
  Merge-Update vs Normal Update
By: a_developer on Thu, 23 March 2006
1 866 Fri, 24 March 2006 00:18
By: rleishman
  Table scan in only 1 of many partitions?
By: kulickd on Fri, 17 March 2006
2 964 Thu, 23 March 2006 17:18
By: kulickd
  TUNING HIGH DISK READ
By: feroze on Fri, 10 March 2006
5 1820 Thu, 23 March 2006 09:49
By: feroze
  Tablespace Fragmentation !!
By: AlinaC on Thu, 23 March 2006
6 5502 Thu, 23 March 2006 07:07
By: Mahesh Rajendran
  tablespace
By: manns on Tue, 21 March 2006
5 1409 Thu, 23 March 2006 03:41
By: Frank
  general query tuning
By: mjschwenger on Sun, 19 March 2006
7 2954 Wed, 22 March 2006 15:11
By: mjschwenger
  A myth of TKPROF output in Oracle 10.1.0.4
By: tphan_au on Tue, 07 March 2006
3 1602 Mon, 20 March 2006 22:25
By: Art Metzer
  Truncation of Queries in Statspack Report
By: ajay_gupta_dr on Mon, 20 March 2006
1 897 Mon, 20 March 2006 06:34
By: Maaher
  Function index
By: panatisudhakar on Sat, 18 March 2006
3 1994 Mon, 20 March 2006 05:08
By: JSI2001
  bitmap index on unstable column
By: a_developer on Thu, 16 March 2006
4 1788 Sat, 18 March 2006 21:51
By: a_developer
  Transaction never fails ..where
By: jagjeet.malhi on Sat, 18 March 2006
0 2899 Sat, 18 March 2006 07:21
By: jagjeet.malhi
  Difference in Execution timing
By: feroze on Fri, 17 March 2006
1 748 Sat, 18 March 2006 00:52
By: Frank
  Log File Sync
By: amitsingla on Fri, 17 March 2006
3 1207 Fri, 17 March 2006 04:56
By: alanm
icon9.gif Interpreting tkprof
By: sophieharris on Sun, 12 March 2006
4 8365 Thu, 16 March 2006 15:42
By: sophieharris
  operation timed out
By: vasudevan on Thu, 16 March 2006
3 873 Thu, 16 March 2006 15:30
By: Mahesh Rajendran
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 Dec 04 16:47:20 CST 2022