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	1618	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	2359	Mon, 10 April 2006 07:45 By: kmsalih
error in SPreport output By: vraman3 on Wed, 05 April 2006	1	3023	Sun, 09 April 2006 23:55 By: vraman3
List vs Range Partitioning By: a_developer on Wed, 05 April 2006	7	7420	Sun, 09 April 2006 23:07 By: rleishman
about PCT in mv_capabilities_table. By: srikanth.raju on Fri, 07 April 2006	1	1967	Sat, 08 April 2006 19:29 By: rleishman
Database speed up By: amkotz on Sat, 08 April 2006	3	1242	Sat, 08 April 2006 06:32 By: Mahesh Rajendran
migrating SYS from DICT to LOCAL By: tridentadm on Fri, 07 April 2006	3	1226	Sat, 08 April 2006 04:18 By: Mahesh Rajendran
Performance Tuning Tool By: suryamz on Thu, 06 April 2006	1	1375	Fri, 07 April 2006 03:55 By: madhusunkara
Is it Oracle 10g slower comparatively Oracle 9i By: sponguru on Fri, 07 April 2006	1	1346	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	1543	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	2103	Tue, 04 April 2006 18:11 By: RaeMarvin
gather_fixed_objects_stats By: orant1 on Mon, 03 April 2006	1	3967	Mon, 03 April 2006 06:36 By: Mahesh Rajendran
Clearing Blocks from Memory By: scottwmackey on Fri, 31 March 2006	4	2138	Mon, 03 April 2006 04:43 By: madhusunkara
Query Speed Slow. By: rvnair123 on Fri, 31 March 2006	3	1879	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	1462	Fri, 31 March 2006 22:49 By: rleishman
generic SGA By: oxalide on Mon, 27 March 2006	1	1368	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	1148	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	1492	Fri, 31 March 2006 01:22 By: rleishman
resolving buffer busy waits By: tridentadm on Sun, 26 March 2006	2	1781	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	1329	Fri, 31 March 2006 00:37 By: madhusunkara
Partition & Performance By: lucas4394 on Sat, 25 March 2006	6	2274	Thu, 30 March 2006 21:32 By: rleishman
Balanced Decision on Index Creation By: faiz_hyd on Mon, 27 March 2006	11	2717	Wed, 29 March 2006 04:11 By: JSI2001
Question about PERFSTAT Tablespace By: Uwe on Wed, 29 March 2006	3	3241	Wed, 29 March 2006 03:15 By: Frank
oracle solaris tuning kernel By: khaledfarid on Wed, 22 March 2006	3	2837	Wed, 29 March 2006 00:07 By: madhusunkara
Global and Local Index By: toshidas2000 on Mon, 27 March 2006	1	1344	Mon, 27 March 2006 22:17 By: rleishman
Materialized View Based on a Union Query By: kishorekumar_1982 on Mon, 27 March 2006	1	1606	Mon, 27 March 2006 22:14 By: rleishman
Different Plan for Inner and Outer Query By: feroze on Wed, 22 March 2006	5	2013	Mon, 27 March 2006 00:16 By: rleishman
information about indexes By: kinjal on Thu, 23 March 2006	7	2779	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	1329	Sun, 26 March 2006 16:16 By: BlackSwan
SQLTRACE AND DB_FILE_SEQUENTIAL_READ By: sumang24 on Wed, 22 March 2006	9	6019	Sat, 25 March 2006 08:56 By: Mahesh Rajendran
Function taking very long to execute By: alfatat on Sat, 25 March 2006	1	1173	Sat, 25 March 2006 05:37 By: Frank
help!!->resolving "cpu time" problem By: rzmni on Wed, 08 March 2006	1	1318	Sat, 25 March 2006 01:03 By: Frank Naude
where is UGA stored ?? By: tridentadm on Thu, 23 March 2006	1	1169	Fri, 24 March 2006 06:02 By: amit_nanote
Merge-Update vs Normal Update By: a_developer on Thu, 23 March 2006	1	1201	Fri, 24 March 2006 00:18 By: rleishman
Table scan in only 1 of many partitions? By: kulickd on Fri, 17 March 2006	2	1302	Thu, 23 March 2006 17:18 By: kulickd
TUNING HIGH DISK READ By: feroze on Fri, 10 March 2006	5	2184	Thu, 23 March 2006 09:49 By: feroze
Tablespace Fragmentation !! By: AlinaC on Thu, 23 March 2006	6	6055	Thu, 23 March 2006 07:07 By: Mahesh Rajendran
tablespace By: manns on Tue, 21 March 2006	5	1844	Thu, 23 March 2006 03:41 By: Frank
general query tuning By: mjschwenger on Sun, 19 March 2006	7	3489	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	2037	Mon, 20 March 2006 22:25 By: Art Metzer