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
How many times Queries/DML statement run over a week. Solaris, 10.2.0.3 By: Oraclist on Tue, 22 July 2008	3	1439	Tue, 22 July 2008 08:29 By: Michel Cadot
Need help to Optimize this query By: srajan on Mon, 21 July 2008	2	1664	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	2416	Mon, 21 July 2008 08:07 By: Michel Cadot
oracle9i Precaution for defining VARCHAR2(4000) By: shrinika on Fri, 18 July 2008	3	1614	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	2220	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	8557	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	2292	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	2096	Fri, 18 July 2008 00:44 By: Michel Cadot
replacing with single update statement Oracle 10g By: kumarbo7 on Wed, 16 July 2008	8	2075	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	2496	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	1392	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	1741	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	2261	Tue, 15 July 2008 02:39 By: Michel Cadot
pls help to reduce some loop 10g By: simplesanju on Thu, 10 July 2008	16	3320	Mon, 14 July 2008 23:11 By: simplesanju
Oracle Query Tuning By: hedonist123 on Mon, 14 July 2008	3	3420	Mon, 14 July 2008 21:59 By: rleishman
Nasty query re-write Oracle 9i By: svguerin3 on Tue, 24 June 2008	25	6036	Mon, 14 July 2008 10:27 By: svguerin3
query performance By: Altitude on Mon, 14 July 2008	1	1203	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	3616	Mon, 14 July 2008 03:13 By: rleishman
Create Index ? By: ArvindBhope on Sat, 12 July 2008	3	1458	Sun, 13 July 2008 10:09 By: Kevin Meade
GATHERING STATISTICS By: acarella on Fri, 11 July 2008	6	2005	Sat, 12 July 2008 17:46 By: Kriptas
Bind variable in a data warehouse By: stegau on Wed, 09 July 2008	4	2823	Fri, 11 July 2008 07:54 By: rleishman
Query running slow Oracle 9i R2, Sun Soalris By: poratips on Wed, 02 July 2008	8	2525	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	5214	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	3272	Wed, 09 July 2008 11:38 By: JRowbottom
Query plan change By: jinga on Wed, 09 July 2008	3	1440	Wed, 09 July 2008 08:30 By: tahpush
update is slow with CLOB data oracle9i By: shrinika on Sat, 28 June 2008	9	8446	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	1468	Tue, 08 July 2008 07:34 By: Michel Cadot
What do Oracle waits mean By: lunaut on Mon, 07 July 2008	2	2170	Mon, 07 July 2008 14:17 By: Michel Cadot
Materialized view not getting used Oracle 10g By: vkumar on Mon, 07 July 2008	1	1505	Mon, 07 July 2008 09:46 By: BlackSwan
UNION causing slow performance Oracle 9i By: svguerin3 on Sat, 05 July 2008	21	37486	Sun, 06 July 2008 08:27 By: Kriptas
Query taking much time Oracle 10g By: virmahi on Thu, 03 July 2008	15	3215	Sat, 05 July 2008 14:17 By: Kriptas
temp space estimation ? By: ArvindBhope on Sat, 05 July 2008	4	1524	Sat, 05 July 2008 10:44 By: Michel Cadot
Oracle10g very slow on windows2003 server Oracle10g By: safhanghauri on Sat, 05 July 2008	1	2448	Sat, 05 July 2008 08:13 By: BlackSwan
How heavy an AWR snapshot is 10g By: lunaut on Wed, 02 July 2008	3	1513	Fri, 04 July 2008 06:03 By: alanm
Problem sorting and inserting huge data (merged) By: ravashingravi on Wed, 02 July 2008	7	2214	Thu, 03 July 2008 17:45 By: coleing
Generate SQL Statements from 10046 trace file By: jochenbandhauer on Thu, 03 July 2008	0	6192	Thu, 03 July 2008 11:26 By: jochenbandhauer
free command 10.2.0.4 By: mafc73 on Wed, 02 July 2008	3	1534	Thu, 03 July 2008 08:53 By: BlackSwan
Query running slow oracle,10202,AIX By: areeb on Tue, 01 July 2008	1	2576	Tue, 01 July 2008 13:39 By: BlackSwan
multiple dbwr processes and multiple archver process Oracle 9.0.2.0.6 Windows Server 2003 By: M.Shakeel Azeem on Fri, 11 January 2008	3	3201	Tue, 01 July 2008 07:25 By: alanm
Best way to partition my table By: kjcamann@gmail.com on Sun, 29 June 2008	7	2695	Mon, 30 June 2008 23:34 By: rleishman