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
Are Stale STATS Any Good v10.2.0.4 SunOS 5.10 x86_64 By: drovnik on Tue, 18 October 2011	2	3433	Thu, 27 October 2011 02:31 By: drovnik
Proving OTT undo reads In post By: Roachcoach on Wed, 26 October 2011	3	3008	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	2982	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	18010	Wed, 26 October 2011 06:01 By: Kevin Meade
Performance Tuning Aix By: sher297 on Sun, 23 October 2011	5	3057	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	2765	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	4788	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	4776	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	16656	Tue, 25 October 2011 02:02 By: LNossov
Optimize MERGE statement Oracle 10g By: tsteinmaurer on Wed, 05 October 2011	10	10631	Mon, 24 October 2011 15:54 By: LNossov
PL/SQL help (performance) Win Xp, Oracle 10g By: rajivn786 on Wed, 19 October 2011	17	4437	Sat, 22 October 2011 16:04 By: LNossov
I/p on tuning select query Oracle 8i By: shyamu on Sat, 22 October 2011	3	3446	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	4250	Fri, 21 October 2011 12:49 By: ThomasG
Need support for Query performance tuning Oracle 11g By: onlijob on Thu, 20 October 2011	10	5346	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	6140	Wed, 19 October 2011 17:41 By: LNossov
Large temporary files Oracle 9i, Centos By: ranjit@buddhaair.com on Mon, 17 October 2011	2	3540	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	3992	Sun, 16 October 2011 00:59 By: Michel Cadot
QUERY Help By: venkatlvr on Sat, 15 October 2011	3	3003	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	8342	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	7450	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	4177	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	13498	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	2649	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	5157	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	3341	Tue, 04 October 2011 12:18 By: LNossov
how to find index to rebuilt oracle 9i By: sathish16787 on Mon, 03 October 2011	2	3187	Tue, 04 October 2011 11:40 By: LNossov
don't know why this baseline doesn't work :/ 11.2.0.1.0 By: piotrtal on Fri, 16 September 2011	3	3295	Tue, 04 October 2011 10:08 By: LNossov
How to view the tables which are in the keep buffer cache???? By: Narmada28 on Sat, 01 October 2011	9	3674	Mon, 03 October 2011 02:54 By: Narmada28
Views which will help in tuning SGA and PGA By: Narmada28 on Sat, 01 October 2011	5	3822	Sat, 01 October 2011 12:05 By: Michel Cadot
optimizer ignoring USE_HASH hint in MERGE Query 10.2.0.3 By: deepa_balu on Fri, 30 September 2011	2	3645	Fri, 30 September 2011 06:42 By: Michel Cadot
Virtual Columns : function based very slow Oracle 11.2.0.2.0 By: ric90 on Thu, 29 September 2011	0	4045	Thu, 29 September 2011 07:00 By: ric90
Query tuning oracle 9i By: sathik on Tue, 27 September 2011	6	3592	Wed, 28 September 2011 03:25 By: Flyby
SQL with more parse 11g By: gkrishn on Tue, 27 September 2011	6	2930	Tue, 27 September 2011 05:39 By: Roachcoach
MERGE Statment repetitive subquery refactoring (3 Merged) Oracle 11g, Windows xP By: ninan on Thu, 22 September 2011	1	2572	Thu, 22 September 2011 13:12 By: BlackSwan
Performance Issue Oracle 10g, Windows XP By: a_oracle on Wed, 21 September 2011	9	9087	Thu, 22 September 2011 07:24 By: a_oracle
Need help to understand in depth about ORA-01555 Oracle , 9.2.0.8, solaris By: sathik on Thu, 22 September 2011	6	5331	Thu, 22 September 2011 06:56 By: Michel Cadot
POWER function slows query way down? 9.2.0.8.0 By: Kevin Meade on Fri, 16 September 2011	14	7723	Sun, 18 September 2011 11:51 By: Kevin Meade
query taking long time 10.2.0.4 By: varunvir on Fri, 16 September 2011	5	2842	Fri, 16 September 2011 14:26 By: varunvir
session_cached_cursors 11gr2 By: fairdaus on Mon, 27 June 2011	11	21199	Fri, 16 September 2011 08:25 By: Michel Cadot
select partition issue 11.2.0.1.0 Windos XP By: andy huang on Thu, 15 September 2011	3	3029	Thu, 15 September 2011 20:27 By: BlackSwan