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
Oracle UNION ALL performance issue Oracle 10g By: victoryhendry on Thu, 09 September 2010	33	25148	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	3111	Wed, 15 September 2010 08:02 By: Michel Cadot
Sql Tunning Concept Oracle 10g By: nagpalgggmailcom on Wed, 15 September 2010	5	2317	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	2228	Wed, 15 September 2010 05:36 By: Michel Cadot
Query performance gain using statistics By: jackman1 on Mon, 09 August 2010	6	4532	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	3635	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	1986	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	3734	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	2931	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	5596	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	3008	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	2590	Fri, 03 September 2010 01:29 By: Its_me_ved
Please tune this query By: shabir46 on Thu, 02 September 2010	8	2901	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	3263	Tue, 31 August 2010 12:04 By: Michel Cadot
Query slow oracle 10g By: prashant_ora on Fri, 20 August 2010	25	5888	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	3064	Tue, 31 August 2010 01:06 By: michael_bialik
search query oracle 10g By: prashant_ora on Fri, 27 August 2010	21	4090	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	1777	Mon, 30 August 2010 02:31 By: Michel Cadot
Perfomance issue while extracting XML data By: harshalonline22 on Wed, 09 June 2010	8	4202	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	1596	Thu, 26 August 2010 00:44 By: Michel Cadot
No Redo for DML? By: amitsingla on Fri, 17 March 2006	25	9806	Wed, 25 August 2010 06:15 By: Roachcoach
materalized view By: prashant_ora on Mon, 23 August 2010	4	4523	Mon, 23 August 2010 09:27 By: Michel Cadot
Query Oracle 9i By: ajaykumarkona on Wed, 18 August 2010	4	1988	Thu, 19 August 2010 16:56 By: cookiemonster
Password profile Oracle 9i.2, Windows. By: muktha_22 on Tue, 17 August 2010	4	1849	Tue, 17 August 2010 14:09 By: Michel Cadot
Index creation oracle 10g By: prashant_ora on Tue, 17 August 2010	2	1646	Tue, 17 August 2010 01:09 By: Michel Cadot
TPC-E benchmarking Oracle 11g/r2 By: dsub42 on Sat, 14 August 2010	1	3057	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	2678	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	11400	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	8378	Fri, 13 August 2010 10:11 By: sathik
how to get explain plan oracle 10g By: prashant_ora on Tue, 10 August 2010	27	5936	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	3316	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	6736	Tue, 10 August 2010 04:39 By: cookiemonster
index creation oracle 10g unix By: prashant_ora on Mon, 09 August 2010	7	2119	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	3255	Sat, 07 August 2010 23:12 By: rleishman
create table statement with union By: prashant_ora on Thu, 05 August 2010	27	4026	Fri, 06 August 2010 13:50 By: Michel Cadot
create table statement ( 1 2) By: prashant_ora on Wed, 04 August 2010	43	6084	Fri, 06 August 2010 05:58 By: Roachcoach
Partitions Oracle 11g By: ravi214u on Thu, 05 August 2010	10	2284	Thu, 05 August 2010 21:34 By: rahulvb
Force Subquery To Use index Oracle 11g, CentOS 5 By: Vackar on Thu, 05 August 2010	5	2799	Thu, 05 August 2010 05:34 By: Vackar
Performance issue - Views inside a view Oracle Database 10g Enterprise Edition Release 10.2.0.3.0 By: dharmspeakz on Tue, 03 August 2010	16	17557	Thu, 05 August 2010 04:09 By: cookiemonster
Difference between cost and bytes 10g By: soraociscocom on Wed, 04 August 2010	1	3773	Wed, 04 August 2010 01:40 By: BlackSwan