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
will effect the performace of DML on Fast refresh of Materialized view Oracle 10g By: victoryhendry on Fri, 24 September 2010	5	4230	Fri, 24 September 2010 08:30 By: cookiemonster
queary taking time Oracle10.2.0.1/linux By: goracle9 on Thu, 23 September 2010	2	3089	Thu, 23 September 2010 04:54 By: goracle9
Performance over a DB link!! By: ankurgodambe on Sun, 10 July 2005	10	14919	Wed, 22 September 2010 07:57 By: rleishman
Performance tunning oracle 8i By: vishalsrivastava on Mon, 20 September 2010	3	3027	Wed, 22 September 2010 00:12 By: Its_me_ved
Oracle UNION ALL performance issue Oracle 10g By: victoryhendry on Thu, 09 September 2010	33	28246	Mon, 20 September 2010 03:17 By: Roachcoach
nested loops 10.2.0.1 linux 32 bit By: Yasir Hashmi on Tue, 14 September 2010	10	4150	Wed, 15 September 2010 08:02 By: Michel Cadot
Sql Tunning Concept Oracle 10g By: nagpalgggmailcom on Wed, 15 September 2010	5	3178	Wed, 15 September 2010 06:16 By: Roachcoach
To find the indexes (used and unused on the table Oracle 10g on "Windows XP" and "Sun Solaris" By: xclusiveravi523 on Wed, 15 September 2010	3	3388	Wed, 15 September 2010 05:36 By: Michel Cadot
Query performance gain using statistics By: jackman1 on Mon, 09 August 2010	6	5553	Tue, 14 September 2010 10:08 By: jackman1
Need to tune query Oracle9i Enterprise Edition Release 9.2.0.8.0 - 64bit Production By: knw15pwr on Wed, 08 September 2010	15	5173	Tue, 14 September 2010 03:46 By: cookiemonster
Procedures not getting executed Oracle 9.2.0.8 (HP-UX) By: indrajit2002 on Mon, 13 September 2010	3	3059	Mon, 13 September 2010 09:20 By: cookiemonster
Standard vs Advanced Compression Windows Server 2008, Oracle 11g R2 By: datadrums on Wed, 18 August 2010	3	5202	Sun, 12 September 2010 18:45 By: Kevin Meade
Is there a better way to rewrite this query? Oracle 11g , Linux By: kvignes1 on Wed, 08 September 2010	8	3925	Sun, 12 September 2010 18:13 By: Kevin Meade
Obtaining 10046 Wait Events for Parallel Slaves 10.2.0.4 / Sparc / Solaris By: rleishman on Fri, 10 September 2010	0	6212	Fri, 10 September 2010 01:42 By: rleishman
Same plan, same data but different performance results Oracle 10 By: psoftneto on Fri, 03 September 2010	10	4293	Mon, 06 September 2010 03:11 By: Yasir Hashmi
Cost of Query is brought down, but taking same time.(merged) Oracle 10g, Windows 2000 By: oraranjangmailcom on Wed, 01 September 2010	7	3629	Fri, 03 September 2010 01:29 By: Its_me_ved
Please tune this query By: shabir46 on Thu, 02 September 2010	8	3936	Thu, 02 September 2010 07:27 By: cookiemonster
Top 5 timed events Windows server,10.2.0.3 By: sekar52 on Tue, 31 August 2010	4	3974	Tue, 31 August 2010 12:04 By: Michel Cadot
Query slow oracle 10g By: prashant_ora on Fri, 20 August 2010	25	7933	Tue, 31 August 2010 01:28 By: michael_bialik
How to fine tune this query ? Oracle 11g R2 By: sourabhsharma149 on Fri, 13 August 2010	11	5655	Tue, 31 August 2010 01:06 By: michael_bialik
search query oracle 10g By: prashant_ora on Fri, 27 August 2010	21	5886	Mon, 30 August 2010 09:37 By: prashant_ora
AWR and ADDM Windows server,10.2.0.3 By: sekar52 on Mon, 30 August 2010	1	2433	Mon, 30 August 2010 02:31 By: Michel Cadot
Perfomance issue while extracting XML data By: harshalonline22 on Wed, 09 June 2010	8	5297	Thu, 26 August 2010 16:39 By: harshalonline22
Get No of rows Processed while Update statment is still running 10.2 By: rawat_me on Wed, 25 August 2010	2	2869	Thu, 26 August 2010 00:44 By: Michel Cadot
No Redo for DML? By: amitsingla on Fri, 17 March 2006	25	12397	Wed, 25 August 2010 06:15 By: Roachcoach
materalized view By: prashant_ora on Mon, 23 August 2010	4	5307	Mon, 23 August 2010 09:27 By: Michel Cadot
Query Oracle 9i By: ajaykumarkona on Wed, 18 August 2010	4	2797	Thu, 19 August 2010 16:56 By: cookiemonster
Password profile Oracle 9i.2, Windows. By: muktha_22 on Tue, 17 August 2010	4	2725	Tue, 17 August 2010 14:09 By: Michel Cadot
Index creation oracle 10g By: prashant_ora on Tue, 17 August 2010	2	2710	Tue, 17 August 2010 01:09 By: Michel Cadot
TPC-E benchmarking Oracle 11g/r2 By: dsub42 on Sat, 14 August 2010	1	4206	Sat, 14 August 2010 21:32 By: BlackSwan
redo logs generating after every 3 min oracle 10.0.2.4/Win 2k3 By: hussain_dilshad on Fri, 13 August 2010	2	3593	Sat, 14 August 2010 00:51 By: hussain_dilshad
Low performing query 10.1.0.5.0 - 64bit, AIX 6 By: cherry on Sun, 23 May 2010	20	13487	Fri, 13 August 2010 11:16 By: Kevin Meade
Requie help to tune the process Oracle,9.2.0.5.0,SunOS 5.9 By: sathik on Thu, 12 August 2010	15	9795	Fri, 13 August 2010 10:11 By: sathik
how to get explain plan oracle 10g By: prashant_ora on Tue, 10 August 2010	27	7934	Wed, 11 August 2010 02:31 By: cookiemonster
Query tuning Oracle,9.0.2.0.5,Sunsolaris By: sathik on Mon, 09 August 2010	20	5013	Wed, 11 August 2010 01:21 By: sathik
Slow Update Oracle 10g on Win 2008 R2 SP2 By: Michael Gaarde on Mon, 09 August 2010	32	9333	Tue, 10 August 2010 04:39 By: cookiemonster
index creation oracle 10g unix By: prashant_ora on Mon, 09 August 2010	7	3047	Mon, 09 August 2010 12:39 By: Michel Cadot
Table Partitioned with Primary key oracle 10.0.2 By: rawat_me on Wed, 04 August 2010	10	5787	Sat, 07 August 2010 23:12 By: rleishman
create table statement with union By: prashant_ora on Thu, 05 August 2010	27	6186	Fri, 06 August 2010 13:50 By: Michel Cadot
create table statement ( 1 2) By: prashant_ora on Wed, 04 August 2010	43	9059	Fri, 06 August 2010 05:58 By: Roachcoach