OraFAQ Forum: Performance Tuning

Home » RDBMS Server » Performance Tuning

Please read the OraFAQ Forum Guide before posting.

Please contribute good answers to the wiki.

Show: Today's Messages :: Unanswered Messages :: Polls :: Message Navigator

Topic	Replies	Views	Last message
Partitioning Table By: faiz_hyd on Sun, 09 April 2006	2	1634	Mon, 10 April 2006 08:48 By: faiz_hyd
Problem ORA-04031 was solved and spfile changed. By: amit_nanote on Mon, 10 April 2006	2	2375	Mon, 10 April 2006 07:45 By: kmsalih
error in SPreport output By: vraman3 on Wed, 05 April 2006	1	3041	Sun, 09 April 2006 23:55 By: vraman3
List vs Range Partitioning By: a_developer on Wed, 05 April 2006	7	7452	Sun, 09 April 2006 23:07 By: rleishman
about PCT in mv_capabilities_table. By: srikanth.raju on Fri, 07 April 2006	1	1983	Sat, 08 April 2006 19:29 By: rleishman
Database speed up By: amkotz on Sat, 08 April 2006	3	1257	Sat, 08 April 2006 06:32 By: Mahesh Rajendran
migrating SYS from DICT to LOCAL By: tridentadm on Fri, 07 April 2006	3	1242	Sat, 08 April 2006 04:18 By: Mahesh Rajendran
Performance Tuning Tool By: suryamz on Thu, 06 April 2006	1	1391	Fri, 07 April 2006 03:55 By: madhusunkara
Is it Oracle 10g slower comparatively Oracle 9i By: sponguru on Fri, 07 April 2006	1	1362	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	1560	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	2121	Tue, 04 April 2006 18:11 By: RaeMarvin
gather_fixed_objects_stats By: orant1 on Mon, 03 April 2006	1	3981	Mon, 03 April 2006 06:36 By: Mahesh Rajendran
Clearing Blocks from Memory By: scottwmackey on Fri, 31 March 2006	4	2159	Mon, 03 April 2006 04:43 By: madhusunkara
Query Speed Slow. By: rvnair123 on Fri, 31 March 2006	3	1894	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	1477	Fri, 31 March 2006 22:49 By: rleishman
generic SGA By: oxalide on Mon, 27 March 2006	1	1386	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	1163	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	1508	Fri, 31 March 2006 01:22 By: rleishman
resolving buffer busy waits By: tridentadm on Sun, 26 March 2006	2	1795	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	1345	Fri, 31 March 2006 00:37 By: madhusunkara
Partition & Performance By: lucas4394 on Sat, 25 March 2006	6	2290	Thu, 30 March 2006 21:32 By: rleishman
Balanced Decision on Index Creation By: faiz_hyd on Mon, 27 March 2006	11	2732	Wed, 29 March 2006 04:11 By: JSI2001
Question about PERFSTAT Tablespace By: Uwe on Wed, 29 March 2006	3	3258	Wed, 29 March 2006 03:15 By: Frank
oracle solaris tuning kernel By: khaledfarid on Wed, 22 March 2006	3	2854	Wed, 29 March 2006 00:07 By: madhusunkara
Global and Local Index By: toshidas2000 on Mon, 27 March 2006	1	1359	Mon, 27 March 2006 22:17 By: rleishman
Materialized View Based on a Union Query By: kishorekumar_1982 on Mon, 27 March 2006	1	1629	Mon, 27 March 2006 22:14 By: rleishman
Different Plan for Inner and Outer Query By: feroze on Wed, 22 March 2006	5	2032	Mon, 27 March 2006 00:16 By: rleishman
information about indexes By: kinjal on Thu, 23 March 2006	7	2796	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	1344	Sun, 26 March 2006 16:16 By: BlackSwan
SQLTRACE AND DB_FILE_SEQUENTIAL_READ By: sumang24 on Wed, 22 March 2006	9	6035	Sat, 25 March 2006 08:56 By: Mahesh Rajendran
Function taking very long to execute By: alfatat on Sat, 25 March 2006	1	1189	Sat, 25 March 2006 05:37 By: Frank
help!!->resolving "cpu time" problem By: rzmni on Wed, 08 March 2006	1	1335	Sat, 25 March 2006 01:03 By: Frank Naude
where is UGA stored ?? By: tridentadm on Thu, 23 March 2006	1	1187	Fri, 24 March 2006 06:02 By: amit_nanote
Merge-Update vs Normal Update By: a_developer on Thu, 23 March 2006	1	1217	Fri, 24 March 2006 00:18 By: rleishman
Table scan in only 1 of many partitions? By: kulickd on Fri, 17 March 2006	2	1320	Thu, 23 March 2006 17:18 By: kulickd
TUNING HIGH DISK READ By: feroze on Fri, 10 March 2006	5	2200	Thu, 23 March 2006 09:49 By: feroze
Tablespace Fragmentation !! By: AlinaC on Thu, 23 March 2006	6	6079	Thu, 23 March 2006 07:07 By: Mahesh Rajendran
tablespace By: manns on Tue, 21 March 2006	5	1860	Thu, 23 March 2006 03:41 By: Frank
general query tuning By: mjschwenger on Sun, 19 March 2006	7	3504	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	2056	Mon, 20 March 2006 22:25 By: Art Metzer