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
Monitoring memory used by oracle process By: Nau on Mon, 10 April 2006	1	2583	Tue, 11 April 2006 05:13 By: madhusunkara
Performance for Full table scan ( Huge data ) By: rawat_me on Mon, 10 April 2006	5	2690	Tue, 11 April 2006 02:22 By: rleishman
Partitioning Table By: faiz_hyd on Sun, 09 April 2006	2	2115	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	3125	Mon, 10 April 2006 07:45 By: kmsalih
error in SPreport output By: vraman3 on Wed, 05 April 2006	1	3621	Sun, 09 April 2006 23:55 By: vraman3
List vs Range Partitioning By: a_developer on Wed, 05 April 2006	7	8236	Sun, 09 April 2006 23:07 By: rleishman
about PCT in mv_capabilities_table. By: srikanth.raju on Fri, 07 April 2006	1	2688	Sat, 08 April 2006 19:29 By: rleishman
Database speed up By: amkotz on Sat, 08 April 2006	3	2593	Sat, 08 April 2006 06:32 By: Mahesh Rajendran
migrating SYS from DICT to LOCAL By: tridentadm on Fri, 07 April 2006	3	2186	Sat, 08 April 2006 04:18 By: Mahesh Rajendran
Performance Tuning Tool By: suryamz on Thu, 06 April 2006	1	2066	Fri, 07 April 2006 03:55 By: madhusunkara
Is it Oracle 10g slower comparatively Oracle 9i By: sponguru on Fri, 07 April 2006	1	1924	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	2328	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	2917	Tue, 04 April 2006 18:11 By: RaeMarvin
gather_fixed_objects_stats By: orant1 on Mon, 03 April 2006	1	4633	Mon, 03 April 2006 06:36 By: Mahesh Rajendran
Clearing Blocks from Memory By: scottwmackey on Fri, 31 March 2006	4	2775	Mon, 03 April 2006 04:43 By: madhusunkara
Query Speed Slow. By: rvnair123 on Fri, 31 March 2006	3	2917	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	1914	Fri, 31 March 2006 22:49 By: rleishman
generic SGA By: oxalide on Mon, 27 March 2006	1	2197	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	2068	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	2143	Fri, 31 March 2006 01:22 By: rleishman
resolving buffer busy waits By: tridentadm on Sun, 26 March 2006	2	2761	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	2054	Fri, 31 March 2006 00:37 By: madhusunkara
Partition & Performance By: lucas4394 on Sat, 25 March 2006	6	3423	Thu, 30 March 2006 21:32 By: rleishman
Balanced Decision on Index Creation By: faiz_hyd on Mon, 27 March 2006	11	3428	Wed, 29 March 2006 04:11 By: JSI2001
Question about PERFSTAT Tablespace By: Uwe on Wed, 29 March 2006	3	4262	Wed, 29 March 2006 03:15 By: Frank
oracle solaris tuning kernel By: khaledfarid on Wed, 22 March 2006	3	3694	Wed, 29 March 2006 00:07 By: madhusunkara
Global and Local Index By: toshidas2000 on Mon, 27 March 2006	1	1863	Mon, 27 March 2006 22:17 By: rleishman
Materialized View Based on a Union Query By: kishorekumar_1982 on Mon, 27 March 2006	1	1986	Mon, 27 March 2006 22:14 By: rleishman
Different Plan for Inner and Outer Query By: feroze on Wed, 22 March 2006	5	2545	Mon, 27 March 2006 00:16 By: rleishman
information about indexes By: kinjal on Thu, 23 March 2006	7	3405	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	2166	Sun, 26 March 2006 16:16 By: BlackSwan
SQLTRACE AND DB_FILE_SEQUENTIAL_READ By: sumang24 on Wed, 22 March 2006	9	6622	Sat, 25 March 2006 08:56 By: Mahesh Rajendran
Function taking very long to execute By: alfatat on Sat, 25 March 2006	1	1823	Sat, 25 March 2006 05:37 By: Frank
help!!->resolving "cpu time" problem By: rzmni on Wed, 08 March 2006	1	2183	Sat, 25 March 2006 01:03 By: Frank Naude
where is UGA stored ?? By: tridentadm on Thu, 23 March 2006	1	2032	Fri, 24 March 2006 06:02 By: amit_nanote
Merge-Update vs Normal Update By: a_developer on Thu, 23 March 2006	1	1887	Fri, 24 March 2006 00:18 By: rleishman
Table scan in only 1 of many partitions? By: kulickd on Fri, 17 March 2006	2	1851	Thu, 23 March 2006 17:18 By: kulickd
TUNING HIGH DISK READ By: feroze on Fri, 10 March 2006	5	2702	Thu, 23 March 2006 09:49 By: feroze
Tablespace Fragmentation !! By: AlinaC on Thu, 23 March 2006	6	6753	Thu, 23 March 2006 07:07 By: Mahesh Rajendran
tablespace By: manns on Tue, 21 March 2006	5	2387	Thu, 23 March 2006 03:41 By: Frank