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 :: Show Polls :: Message Navigator

Topic	Replies	Views	Last message
Shrinking index Oracle 10.2.0.3,Windows server 2003 64 bit By: eafaisal on Tue, 15 November 2011	7	520	Wed, 16 November 2011 01:30 By: Michel Cadot
index monitoring oracle 10g By: prashant_ora on Thu, 26 August 2010	23	2578	Fri, 11 November 2011 16:31 By: LNossov
Merge statement tuning for 100M records in table ( 1 2) By: sachi09 on Mon, 31 October 2011	49	1873	Tue, 08 November 2011 04:35 By: LNossov
Need help (2 Merged) By: supriyadba1 on Mon, 07 November 2011	14	864	Tue, 08 November 2011 00:53 By: supriyadba1
SQL tuning 11.2.0.2 By: singh09 on Sun, 06 November 2011	3	686	Mon, 07 November 2011 01:17 By: LNossov
Reducing Hard parses Oracle 10g, 10.2.0.3.0, Linux By: Rags123 on Wed, 02 November 2011	30	3342	Fri, 04 November 2011 05:00 By: LNossov
Doubt about Tuning SQL Oracle 11g R2 By: aucrun on Thu, 03 November 2011	8	727	Thu, 03 November 2011 12:25 By: aucrun
sql tunning help required 11.1.0.7 By: nut_shut on Mon, 12 September 2011	4	601	Wed, 02 November 2011 13:12 By: Flyby
Compare current row values with previous one until mismatch Oracle 10g By: asakchris on Wed, 02 November 2011	7	561	Wed, 02 November 2011 05:25 By: Michel Cadot
Parallelism in queries By: manojbe09 on Thu, 20 October 2011	4	496	Sun, 30 October 2011 23:55 By: manojbe09
Bulk update performance issue Oracle 11g, Windows XP By: ninan on Sat, 01 October 2011	26	3834	Sat, 29 October 2011 19:54 By: Kevin Meade
buffer busy wait Linux 2.6.18-92.1.13.el5 By: dba_7722 on Tue, 25 October 2011	20	1647	Fri, 28 October 2011 16:12 By: LNossov
Reading explain plan 11GR2 RAC on Windows By: Kwisatz78 on Mon, 24 October 2011	4	577	Fri, 28 October 2011 10:21 By: Vackar
Query performance diff Oracle 10.2.0.1.0 CentOS 5 By: Vackar on Tue, 25 October 2011	12	480	Fri, 28 October 2011 06:41 By: cookiemonster
Tuning my first query 11GR2 RAC on Windows By: Kwisatz78 on Wed, 26 October 2011	10	829	Thu, 27 October 2011 04:15 By: cookiemonster
Are Stale STATS Any Good v10.2.0.4 SunOS 5.10 x86_64 By: drovnik on Tue, 18 October 2011	2	926	Thu, 27 October 2011 02:31 By: drovnik
Proving OTT undo reads In post By: Roachcoach on Wed, 26 October 2011	3	649	Wed, 26 October 2011 08:50 By: Roachcoach
Performance Issue after Bulk Insertion Oracle Database 10g Enterprise Edition Release 10.2.0.4.0 - 64bi By: Manoj.Gupta.91 on Tue, 04 October 2011	2	511	Wed, 26 October 2011 06:57 By: Kevin Meade
DECODE in WHERE CLAUSE Performance Oracle 11g, Windows XP By: ninan on Mon, 17 October 2011	9	4009	Wed, 26 October 2011 06:01 By: Kevin Meade
Performance Tuning Aix By: sher297 on Sun, 23 October 2011	5	569	Wed, 26 October 2011 04:53 By: Kevin Meade
executions 10.2.0.4, Windows 2003 By: sant_new on Tue, 25 October 2011	3	698	Tue, 25 October 2011 13:16 By: BlackSwan
Tracing long running program 10.2.0.4, Windows 2003 By: sant_new on Tue, 25 October 2011	14	939	Tue, 25 October 2011 12:49 By: Michel Cadot
Index on Range-List Subpartitions Table using template Oracle 11.2.0.2.0 By: ric90 on Mon, 24 October 2011	4	1118	Tue, 25 October 2011 08:12 By: LNossov
Snap IDs not found for awr reports generation Oracle 11gR2, RHEL 5 By: User01 on Mon, 24 October 2011	15	7060	Tue, 25 October 2011 02:02 By: LNossov
Optimize MERGE statement Oracle 10g By: tsteinmaurer on Wed, 05 October 2011	10	3086	Mon, 24 October 2011 15:54 By: LNossov
PL/SQL help (performance) Win Xp, Oracle 10g By: rajivn786 on Wed, 19 October 2011	17	741	Sat, 22 October 2011 16:04 By: LNossov
I/p on tuning select query Oracle 8i By: shyamu on Sat, 22 October 2011	3	624	Sat, 22 October 2011 15:52 By: BlackSwan
Tune the query.. Oracle 11.1.0.6.0 By: muralikri on Fri, 21 October 2011	12	535	Fri, 21 October 2011 12:49 By: ThomasG
Need support for Query performance tuning Oracle 11g By: onlijob on Thu, 20 October 2011	10	564	Fri, 21 October 2011 02:59 By: Roachcoach
To verify if a row exists (index range scan) Oracle 10.2.0.3 By: Its_me_ved on Tue, 18 October 2011	4	3167	Wed, 19 October 2011 17:41 By: LNossov
Large temporary files Oracle 9i, Centos By: ranjit@buddhaair.com on Mon, 17 October 2011	2	681	Mon, 17 October 2011 06:53 By: ranjit@buddhaair.com
Suggestions of manipulating 3 crores of data Oracle 8i By: shyamu on Sat, 15 October 2011	8	895	Sun, 16 October 2011 00:59 By: Michel Cadot
QUERY Help By: venkatlvr on Sat, 15 October 2011	3	517	Sat, 15 October 2011 05:35 By: John Watson
The query was running before 11g upgrade 11.2.0.2.2 By: getzeeshan on Fri, 07 October 2011	39	1551	Fri, 14 October 2011 09:07 By: getzeeshan
sga,pga parameter resizing hp-ux ,oracle 10g(rel 2) By: dbaoracleinin on Thu, 15 September 2011	5	2239	Wed, 12 October 2011 09:34 By: dbaoracleinin
Slower DB response [Oracle 10g on Solaris 5.10] Oracle 10g on Solaris 5.10 By: suddhasatwa_bhaumik on Tue, 11 October 2011	4	1097	Tue, 11 October 2011 09:49 By: suddhasatwa_bhaumik
Performance Issue (merged 2) Oracle DB,11.2.0.1.0,Linux 2.6.18-194.el5PAE By: crussed_sonu on Mon, 10 October 2011	16	4120	Tue, 11 October 2011 04:02 By: crussed_sonu
performance problem (Hit Ratio) Oracle 10g,windows server 2003 By: oradba123 on Mon, 10 October 2011	2	648	Mon, 10 October 2011 03:53 By: Michel Cadot
Tuning help needed Oracle 11.1.0.7.0 By: naveenreddy on Fri, 09 September 2011	18	1006	Wed, 05 October 2011 02:55 By: LNossov
Very Bad Performance After ReOrg v92080 Enterprise - SPARC 8 64bit By: drovnik on Tue, 04 October 2011	3	669	Tue, 04 October 2011 12:18 By: LNossov