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
Index on Range-List Subpartitions Table using template Oracle 11.2.0.2.0 By: ric90 on Mon, 24 October 2011	4	3804	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	14560	Tue, 25 October 2011 02:02 By: LNossov
Optimize MERGE statement Oracle 10g By: tsteinmaurer on Wed, 05 October 2011	10	9264	Mon, 24 October 2011 15:54 By: LNossov
PL/SQL help (performance) Win Xp, Oracle 10g By: rajivn786 on Wed, 19 October 2011	17	2952	Sat, 22 October 2011 16:04 By: LNossov
I/p on tuning select query Oracle 8i By: shyamu on Sat, 22 October 2011	3	2101	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	2900	Fri, 21 October 2011 12:49 By: ThomasG
Need support for Query performance tuning Oracle 11g By: onlijob on Thu, 20 October 2011	10	2660	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	4972	Wed, 19 October 2011 17:41 By: LNossov
Large temporary files Oracle 9i, Centos By: ranjit@buddhaair.com on Mon, 17 October 2011	2	1865	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	2752	Sun, 16 October 2011 00:59 By: Michel Cadot
QUERY Help By: venkatlvr on Sat, 15 October 2011	3	2117	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	5806	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	5641	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	2210	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	11800	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	1595	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	3804	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	1891	Tue, 04 October 2011 12:18 By: LNossov
how to find index to rebuilt oracle 9i By: sathish16787 on Mon, 03 October 2011	2	2300	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	2358	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	2614	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	2118	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	2162	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	3258	Thu, 29 September 2011 07:00 By: ric90
Query tuning oracle 9i By: sathik on Tue, 27 September 2011	6	2457	Wed, 28 September 2011 03:25 By: Flyby
SQL with more parse 11g By: gkrishn on Tue, 27 September 2011	6	1882	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	1669	Thu, 22 September 2011 13:12 By: BlackSwan
Performance Issue Oracle 10g, Windows XP By: a_oracle on Wed, 21 September 2011	9	7844	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	4152	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	5843	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	1853	Fri, 16 September 2011 14:26 By: varunvir
session_cached_cursors 11gr2 By: fairdaus on Mon, 27 June 2011	11	19675	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	2018	Thu, 15 September 2011 20:27 By: BlackSwan
"NOT IN" REPLACE WITH "MINUS" Oracle 10gR2 By: thinknightgmailcom on Thu, 15 September 2011	1	1548	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	3620	Tue, 13 September 2011 08:29 By: cookiemonster
pl/sql oracle 10g By: zodiacsom on Wed, 07 September 2011	24	3245	Mon, 12 September 2011 23:13 By: Michel Cadot
Advice on Gather_stats Oracle 8i, 9i and 10G By: sathik on Tue, 06 September 2011	23	5155	Sun, 11 September 2011 03:38 By: Michel Cadot
Don't Know how to start performance tuning. Oracle Database 10g Enterprise Edition Release 10.2.0.4.0 - 64bit By: Manoj.Gupta.91 on Fri, 09 September 2011	4	2548	Sat, 10 September 2011 10:55 By: halim
How to find out all the queries that are executed in particular range of time in oracle instance. Oracle 10g [10.2.0.3.0] windows 7 By: gopieee16 on Fri, 09 September 2011	3	1492	Fri, 09 September 2011 07:37 By: Michel Cadot
Performance issue Oracle 10g, wondows XP By: a_oracle on Tue, 06 September 2011	3	1601	Fri, 09 September 2011 03:56 By: cookiemonster