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
performance issues in insert stmt Oracle, 10g, windows XP By: jyothsna1612 on Wed, 23 July 2008	1	1935	Wed, 23 July 2008 05:28 By: Michel Cadot
Slow query with customer data Oracle 10.2.0.3.0 on Solaris 10 By: elmu on Thu, 17 July 2008	8	4463	Tue, 22 July 2008 13:19 By: Kriptas
Better way to handle this query? Oracle 9i By: Olivia on Tue, 22 July 2008	5	3185	Tue, 22 July 2008 11:00 By: BlackSwan
optimize queries oracle 10g By: acarella on Fri, 18 July 2008	4	2475	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	2155	Tue, 22 July 2008 08:29 By: Michel Cadot
Need help to Optimize this query By: srajan on Mon, 21 July 2008	2	2063	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	2857	Mon, 21 July 2008 08:07 By: Michel Cadot
oracle9i Precaution for defining VARCHAR2(4000) By: shrinika on Fri, 18 July 2008	3	2290	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	3448	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	9026	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	3134	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	2450	Fri, 18 July 2008 00:44 By: Michel Cadot
replacing with single update statement Oracle 10g By: kumarbo7 on Wed, 16 July 2008	8	2856	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	3230	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	2275	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	2717	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	3541	Tue, 15 July 2008 02:39 By: Michel Cadot
pls help to reduce some loop 10g By: simplesanju on Thu, 10 July 2008	16	4487	Mon, 14 July 2008 23:11 By: simplesanju
Oracle Query Tuning By: hedonist123 on Mon, 14 July 2008	3	3855	Mon, 14 July 2008 21:59 By: rleishman
Nasty query re-write Oracle 9i By: svguerin3 on Tue, 24 June 2008	25	7814	Mon, 14 July 2008 10:27 By: svguerin3
query performance By: Altitude on Mon, 14 July 2008	1	1651	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	4367	Mon, 14 July 2008 03:13 By: rleishman
Create Index ? By: ArvindBhope on Sat, 12 July 2008	3	1877	Sun, 13 July 2008 10:09 By: Kevin Meade
GATHERING STATISTICS By: acarella on Fri, 11 July 2008	6	3442	Sat, 12 July 2008 17:46 By: Kriptas
Bind variable in a data warehouse By: stegau on Wed, 09 July 2008	4	3893	Fri, 11 July 2008 07:54 By: rleishman
Query running slow Oracle 9i R2, Sun Soalris By: poratips on Wed, 02 July 2008	8	3080	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	7107	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	3791	Wed, 09 July 2008 11:38 By: JRowbottom
Query plan change By: jinga on Wed, 09 July 2008	3	2024	Wed, 09 July 2008 08:30 By: tahpush
update is slow with CLOB data oracle9i By: shrinika on Sat, 28 June 2008	9	9254	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	2019	Tue, 08 July 2008 07:34 By: Michel Cadot
What do Oracle waits mean By: lunaut on Mon, 07 July 2008	2	3066	Mon, 07 July 2008 14:17 By: Michel Cadot
Materialized view not getting used Oracle 10g By: vkumar on Mon, 07 July 2008	1	2344	Mon, 07 July 2008 09:46 By: BlackSwan
UNION causing slow performance Oracle 9i By: svguerin3 on Sat, 05 July 2008	21	40425	Sun, 06 July 2008 08:27 By: Kriptas
Query taking much time Oracle 10g By: virmahi on Thu, 03 July 2008	15	4520	Sat, 05 July 2008 14:17 By: Kriptas
temp space estimation ? By: ArvindBhope on Sat, 05 July 2008	4	2888	Sat, 05 July 2008 10:44 By: Michel Cadot
Oracle10g very slow on windows2003 server Oracle10g By: safhanghauri on Sat, 05 July 2008	1	3276	Sat, 05 July 2008 08:13 By: BlackSwan
How heavy an AWR snapshot is 10g By: lunaut on Wed, 02 July 2008	3	2668	Fri, 04 July 2008 06:03 By: alanm
Problem sorting and inserting huge data (merged) By: ravashingravi on Wed, 02 July 2008	7	2787	Thu, 03 July 2008 17:45 By: coleing
Generate SQL Statements from 10046 trace file By: jochenbandhauer on Thu, 03 July 2008	0	6593	Thu, 03 July 2008 11:26 By: jochenbandhauer