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
Better way to handle this query? Oracle 9i By: Olivia on Tue, 22 July 2008	5	2967	Tue, 22 July 2008 11:00 By: BlackSwan
optimize queries oracle 10g By: acarella on Fri, 18 July 2008	4	2289	Tue, 22 July 2008 08:30 By: michael_bialik
How many times Queries/DML statement run over a week. Solaris, 10.2.0.3 By: Oraclist on Tue, 22 July 2008	3	1894	Tue, 22 July 2008 08:29 By: Michel Cadot
Need help to Optimize this query By: srajan on Mon, 21 July 2008	2	1903	Tue, 22 July 2008 05:49 By: rajatratewal
How to enable Bitmap Index Oracle 10G Express Edition By: Swadhin on Mon, 21 July 2008	1	2727	Mon, 21 July 2008 08:07 By: Michel Cadot
oracle9i Precaution for defining VARCHAR2(4000) By: shrinika on Fri, 18 July 2008	3	1883	Sun, 20 July 2008 00:55 By: Michel Cadot
maximum number of process exceeded oracle 9i-9.2.0.1.0-Red Hat Linux RHAS 2.1 By: jimit_shaili on Sat, 19 July 2008	4	3259	Sat, 19 July 2008 03:34 By: Michel Cadot
user I/O and read by other session waits oracle 10.2.0.3 soalris 10 By: kumar.joy on Fri, 18 July 2008	0	8909	Fri, 18 July 2008 17:39 By: kumar.joy
query tuning oracle,9.2.0.8,window By: vickey_sagar1 on Mon, 14 July 2008	9	2701	Fri, 18 July 2008 12:11 By: Kriptas
Effect on physical standby database oracle 9i-9.2.0.1.0-Red Hat Linux RHAS 2.1 By: jimit_shaili on Fri, 18 July 2008	1	2298	Fri, 18 July 2008 00:44 By: Michel Cadot
replacing with single update statement Oracle 10g By: kumarbo7 on Wed, 16 July 2008	8	2592	Thu, 17 July 2008 22:40 By: kumarbo7
Oracle runs SLOWER on XEON than Pentium Dual Oracle 8.1, Windows 2003 Server By: tranzicija on Thu, 17 July 2008	7	2872	Thu, 17 July 2008 08:09 By: tranzicija
table caching oracle, 9i R1, Win XP By: manish.verma@sify.com on Tue, 15 July 2008	2	2093	Wed, 16 July 2008 07:32 By: JRowbottom
what are the various steps of query processing Oracle 9i By: manish.verma@sify.com on Thu, 10 July 2008	3	2470	Tue, 15 July 2008 11:36 By: Michel Cadot
Index Partitioning Oracle 9i,version-92010,OS-Linux RHAS 2.1 By: jimit_shaili on Mon, 14 July 2008	9	3254	Tue, 15 July 2008 02:39 By: Michel Cadot
pls help to reduce some loop 10g By: simplesanju on Thu, 10 July 2008	16	3959	Mon, 14 July 2008 23:11 By: simplesanju
Oracle Query Tuning By: hedonist123 on Mon, 14 July 2008	3	3664	Mon, 14 July 2008 21:59 By: rleishman
Nasty query re-write Oracle 9i By: svguerin3 on Tue, 24 June 2008	25	6989	Mon, 14 July 2008 10:27 By: svguerin3
query performance By: Altitude on Mon, 14 July 2008	1	1487	Mon, 14 July 2008 07:59 By: pablolee
how to force parallel to subquery of select statement ? By: eyuval26 on Sun, 13 July 2008	7	4070	Mon, 14 July 2008 03:13 By: rleishman
Create Index ? By: ArvindBhope on Sat, 12 July 2008	3	1700	Sun, 13 July 2008 10:09 By: Kevin Meade
GATHERING STATISTICS By: acarella on Fri, 11 July 2008	6	3177	Sat, 12 July 2008 17:46 By: Kriptas
Bind variable in a data warehouse By: stegau on Wed, 09 July 2008	4	3711	Fri, 11 July 2008 07:54 By: rleishman
Query running slow Oracle 9i R2, Sun Soalris By: poratips on Wed, 02 July 2008	8	2819	Thu, 10 July 2008 13:35 By: poratips
ORACLE TRACE : maximum number of recursive SQL levels (50) exceeded Linux 2.6.9-5.ELsmp x86_64 x86_64 x86_64 GNU/Linux By: ashish1986 on Wed, 09 July 2008	7	6743	Thu, 10 July 2008 05:54 By: JRowbottom
SQL Tuning (Multicolumn Range Parttiion Pruning) 10.2.0.2 By: sujitdba on Tue, 08 July 2008	3	3576	Wed, 09 July 2008 11:38 By: JRowbottom
Query plan change By: jinga on Wed, 09 July 2008	3	1702	Wed, 09 July 2008 08:30 By: tahpush
update is slow with CLOB data oracle9i By: shrinika on Sat, 28 June 2008	9	8868	Tue, 08 July 2008 10:47 By: shrinika
Optimizing the Query Oracle 10g release 2, OS Server Unix, OS Client Window XP By: itroome on Tue, 08 July 2008	1	1840	Tue, 08 July 2008 07:34 By: Michel Cadot
What do Oracle waits mean By: lunaut on Mon, 07 July 2008	2	2812	Mon, 07 July 2008 14:17 By: Michel Cadot
Materialized view not getting used Oracle 10g By: vkumar on Mon, 07 July 2008	1	2168	Mon, 07 July 2008 09:46 By: BlackSwan
UNION causing slow performance Oracle 9i By: svguerin3 on Sat, 05 July 2008	21	38715	Sun, 06 July 2008 08:27 By: Kriptas
Query taking much time Oracle 10g By: virmahi on Thu, 03 July 2008	15	3744	Sat, 05 July 2008 14:17 By: Kriptas
temp space estimation ? By: ArvindBhope on Sat, 05 July 2008	4	2611	Sat, 05 July 2008 10:44 By: Michel Cadot
Oracle10g very slow on windows2003 server Oracle10g By: safhanghauri on Sat, 05 July 2008	1	3061	Sat, 05 July 2008 08:13 By: BlackSwan
How heavy an AWR snapshot is 10g By: lunaut on Wed, 02 July 2008	3	2473	Fri, 04 July 2008 06:03 By: alanm
Problem sorting and inserting huge data (merged) By: ravashingravi on Wed, 02 July 2008	7	2511	Thu, 03 July 2008 17:45 By: coleing
Generate SQL Statements from 10046 trace file By: jochenbandhauer on Thu, 03 July 2008	0	6491	Thu, 03 July 2008 11:26 By: jochenbandhauer
free command 10.2.0.4 By: mafc73 on Wed, 02 July 2008	3	1738	Thu, 03 July 2008 08:53 By: BlackSwan
Query running slow oracle,10202,AIX By: areeb on Tue, 01 July 2008	1	2781	Tue, 01 July 2008 13:39 By: BlackSwan