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
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	1983	Wed, 15 September 2010 05:36 By: Michel Cadot
Query performance gain using statistics By: jackman1 on Mon, 09 August 2010	6	4252	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	3310	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	1748	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	3451	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	2644	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	5371	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	2703	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	2347	Fri, 03 September 2010 01:29 By: Its_me_ved
Please tune this query By: shabir46 on Thu, 02 September 2010	8	2632	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	3019	Tue, 31 August 2010 12:04 By: Michel Cadot
Query slow oracle 10g By: prashant_ora on Fri, 20 August 2010	25	5378	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	2744	Tue, 31 August 2010 01:06 By: michael_bialik
search query oracle 10g By: prashant_ora on Fri, 27 August 2010	21	3618	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	1539	Mon, 30 August 2010 02:31 By: Michel Cadot
Perfomance issue while extracting XML data By: harshalonline22 on Wed, 09 June 2010	8	3848	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	1366	Thu, 26 August 2010 00:44 By: Michel Cadot
No Redo for DML? By: amitsingla on Fri, 17 March 2006	25	9228	Wed, 25 August 2010 06:15 By: Roachcoach
materalized view By: prashant_ora on Mon, 23 August 2010	4	4275	Mon, 23 August 2010 09:27 By: Michel Cadot
Query Oracle 9i By: ajaykumarkona on Wed, 18 August 2010	4	1759	Thu, 19 August 2010 16:56 By: cookiemonster
Password profile Oracle 9i.2, Windows. By: muktha_22 on Tue, 17 August 2010	4	1628	Tue, 17 August 2010 14:09 By: Michel Cadot
Index creation oracle 10g By: prashant_ora on Tue, 17 August 2010	2	1416	Tue, 17 August 2010 01:09 By: Michel Cadot
TPC-E benchmarking Oracle 11g/r2 By: dsub42 on Sat, 14 August 2010	1	2840	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	2439	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	10777	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	7989	Fri, 13 August 2010 10:11 By: sathik
how to get explain plan oracle 10g By: prashant_ora on Tue, 10 August 2010	27	5361	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	2959	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	6025	Tue, 10 August 2010 04:39 By: cookiemonster
index creation oracle 10g unix By: prashant_ora on Mon, 09 August 2010	7	1850	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	2977	Sat, 07 August 2010 23:12 By: rleishman
create table statement with union By: prashant_ora on Thu, 05 August 2010	27	3577	Fri, 06 August 2010 13:50 By: Michel Cadot
create table statement ( 1 2) By: prashant_ora on Wed, 04 August 2010	43	5281	Fri, 06 August 2010 05:58 By: Roachcoach
Partitions Oracle 11g By: ravi214u on Thu, 05 August 2010	10	1955	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	2558	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	17183	Thu, 05 August 2010 04:09 By: cookiemonster
Difference between cost and bytes 10g By: soraociscocom on Wed, 04 August 2010	1	3562	Wed, 04 August 2010 01:40 By: BlackSwan
delete no of records By: prashant_ora on Tue, 03 August 2010	14	2639	Wed, 04 August 2010 00:07 By: BlackSwan
Query doesn't use Materialized View Oracle 10g By: bustaliz on Tue, 03 August 2010	1	1534	Tue, 03 August 2010 10:19 By: Michel Cadot
run explain plan syntax , show error window series By: JADYCHEN on Tue, 03 August 2010	4	6833	Tue, 03 August 2010 02:44 By: JADYCHEN