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

    Replies Views Last message
  Performance for Full table scan ( Huge data )
By: rawat_me on Mon, 10 April 2006
5 2435 Tue, 11 April 2006 02:22
By: rleishman
  Partitioning Table
By: faiz_hyd on Sun, 09 April 2006
2 1882 Mon, 10 April 2006 08:48
By: faiz_hyd
icon5.gif Problem ORA-04031 was solved and spfile changed.
By: amit_nanote on Mon, 10 April 2006
2 2629 Mon, 10 April 2006 07:45
By: kmsalih
  error in SPreport output
By: vraman3 on Wed, 05 April 2006
1 3261 Sun, 09 April 2006 23:55
By: vraman3
  List vs Range Partitioning
By: a_developer on Wed, 05 April 2006
7 7824 Sun, 09 April 2006 23:07
By: rleishman
  about PCT in mv_capabilities_table.
By: srikanth.raju on Fri, 07 April 2006
1 2217 Sat, 08 April 2006 19:29
By: rleishman
  Database speed up
By: amkotz on Sat, 08 April 2006
3 1498 Sat, 08 April 2006 06:32
By: Mahesh Rajendran
  migrating SYS from DICT to LOCAL
By: tridentadm on Fri, 07 April 2006
3 1479 Sat, 08 April 2006 04:18
By: Mahesh Rajendran
  Performance Tuning Tool
By: suryamz on Thu, 06 April 2006
1 1602 Fri, 07 April 2006 03:55
By: madhusunkara
  Is it Oracle 10g slower comparatively Oracle 9i
By: sponguru on Fri, 07 April 2006
1 1612 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 1808 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 2386 Tue, 04 April 2006 18:11
By: RaeMarvin
  gather_fixed_objects_stats
By: orant1 on Mon, 03 April 2006
1 4201 Mon, 03 April 2006 06:36
By: Mahesh Rajendran
  Clearing Blocks from Memory
By: scottwmackey on Fri, 31 March 2006
4 2416 Mon, 03 April 2006 04:43
By: madhusunkara
  Query Speed Slow.
By: rvnair123 on Fri, 31 March 2006
3 2112 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 1703 Fri, 31 March 2006 22:49
By: rleishman
  generic SGA
By: oxalide on Mon, 27 March 2006
1 1609 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 1401 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 1752 Fri, 31 March 2006 01:22
By: rleishman
  resolving buffer busy waits
By: tridentadm on Sun, 26 March 2006
2 2051 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 1551 Fri, 31 March 2006 00:37
By: madhusunkara
icon5.gif Partition & Performance
By: lucas4394 on Sat, 25 March 2006
6 2574 Thu, 30 March 2006 21:32
By: rleishman
  Balanced Decision on Index Creation
By: faiz_hyd on Mon, 27 March 2006
11 3040 Wed, 29 March 2006 04:11
By: JSI2001
  Question about PERFSTAT Tablespace
By: Uwe on Wed, 29 March 2006
3 3500 Wed, 29 March 2006 03:15
By: Frank
  oracle solaris tuning kernel
By: khaledfarid on Wed, 22 March 2006
3 3073 Wed, 29 March 2006 00:07
By: madhusunkara
  Global and Local Index
By: toshidas2000 on Mon, 27 March 2006
1 1570 Mon, 27 March 2006 22:17
By: rleishman
  Materialized View Based on a Union Query
By: kishorekumar_1982 on Mon, 27 March 2006
1 1857 Mon, 27 March 2006 22:14
By: rleishman
  Different Plan for Inner and Outer Query
By: feroze on Wed, 22 March 2006
5 2263 Mon, 27 March 2006 00:16
By: rleishman
  information about indexes
By: kinjal on Thu, 23 March 2006
7 3046 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 1555 Sun, 26 March 2006 16:16
By: BlackSwan
  SQLTRACE AND DB_FILE_SEQUENTIAL_READ
By: sumang24 on Wed, 22 March 2006
9 6288 Sat, 25 March 2006 08:56
By: Mahesh Rajendran
  Function taking very long to execute
By: alfatat on Sat, 25 March 2006
1 1421 Sat, 25 March 2006 05:37
By: Frank
  help!!->resolving "cpu time" problem
By: rzmni on Wed, 08 March 2006
1 1561 Sat, 25 March 2006 01:03
By: Frank Naude
  where is UGA stored ??
By: tridentadm on Thu, 23 March 2006
1 1403 Fri, 24 March 2006 06:02
By: amit_nanote
  Merge-Update vs Normal Update
By: a_developer on Thu, 23 March 2006
1 1429 Fri, 24 March 2006 00:18
By: rleishman
  Table scan in only 1 of many partitions?
By: kulickd on Fri, 17 March 2006
2 1569 Thu, 23 March 2006 17:18
By: kulickd
  TUNING HIGH DISK READ
By: feroze on Fri, 10 March 2006
5 2441 Thu, 23 March 2006 09:49
By: feroze
  Tablespace Fragmentation !!
By: AlinaC on Thu, 23 March 2006
6 6405 Thu, 23 March 2006 07:07
By: Mahesh Rajendran
  tablespace
By: manns on Tue, 21 March 2006
5 2119 Thu, 23 March 2006 03:41
By: Frank
  general query tuning
By: mjschwenger on Sun, 19 March 2006
7 3783 Wed, 22 March 2006 15:11
By: mjschwenger
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: Mon Sep 16 09:54:54 CDT 2024