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
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	2090	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	17384	Wed, 26 October 2011 06:01 By: Kevin Meade
Performance Tuning Aix By: sher297 on Sun, 23 October 2011	5	2544	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	2381	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	4092	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	4353	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	15742	Tue, 25 October 2011 02:02 By: LNossov
Optimize MERGE statement Oracle 10g By: tsteinmaurer on Wed, 05 October 2011	10	9997	Mon, 24 October 2011 15:54 By: LNossov
PL/SQL help (performance) Win Xp, Oracle 10g By: rajivn786 on Wed, 19 October 2011	17	3657	Sat, 22 October 2011 16:04 By: LNossov
I/p on tuning select query Oracle 8i By: shyamu on Sat, 22 October 2011	3	2613	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	3518	Fri, 21 October 2011 12:49 By: ThomasG
Need support for Query performance tuning Oracle 11g By: onlijob on Thu, 20 October 2011	10	3229	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	5546	Wed, 19 October 2011 17:41 By: LNossov
Large temporary files Oracle 9i, Centos By: ranjit@buddhaair.com on Mon, 17 October 2011	2	2366	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	3277	Sun, 16 October 2011 00:59 By: Michel Cadot
QUERY Help By: venkatlvr on Sat, 15 October 2011	3	2617	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	6819	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	6230	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	2735	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	12680	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	2084	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	4483	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	2382	Tue, 04 October 2011 12:18 By: LNossov
how to find index to rebuilt oracle 9i By: sathish16787 on Mon, 03 October 2011	2	2823	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	2910	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	3131	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	2643	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	2642	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	3732	Thu, 29 September 2011 07:00 By: ric90
Query tuning oracle 9i By: sathik on Tue, 27 September 2011	6	2986	Wed, 28 September 2011 03:25 By: Flyby
SQL with more parse 11g By: gkrishn on Tue, 27 September 2011	6	2356	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	2174	Thu, 22 September 2011 13:12 By: BlackSwan
Performance Issue Oracle 10g, Windows XP By: a_oracle on Wed, 21 September 2011	9	8398	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	4682	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	6691	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	2328	Fri, 16 September 2011 14:26 By: varunvir
session_cached_cursors 11gr2 By: fairdaus on Mon, 27 June 2011	11	20413	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	2499	Thu, 15 September 2011 20:27 By: BlackSwan
"NOT IN" REPLACE WITH "MINUS" Oracle 10gR2 By: thinknightgmailcom on Thu, 15 September 2011	1	1980	Thu, 15 September 2011 07:04 By: Michel Cadot
Perfomance problem with select distinct from cartesian join with OR-ed filter Production: (11.2.0.1, Windows Server x64); Test: (9.2.01, Windows XP) By: malishich on Mon, 12 September 2011	13	4221	Tue, 13 September 2011 08:29 By: cookiemonster