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
I/p on tuning select query Oracle 8i By: shyamu on Sat, 22 October 2011	3	515	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	444	Fri, 21 October 2011 12:49 By: ThomasG
Need support for Query performance tuning Oracle 11g By: onlijob on Thu, 20 October 2011	10	451	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	2771	Wed, 19 October 2011 17:41 By: LNossov
Large temporary files Oracle 9i, Centos By: ranjit@buddhaair.com on Mon, 17 October 2011	2	548	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	746	Sun, 16 October 2011 00:59 By: Michel Cadot
QUERY Help By: venkatlvr on Sat, 15 October 2011	3	396	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	1283	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	1677	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	845	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	3244	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	589	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	774	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	606	Tue, 04 October 2011 12:18 By: LNossov
how to find index to rebuilt oracle 9i By: sathish16787 on Mon, 03 October 2011	2	821	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	601	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	509	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	679	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	840	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	1515	Thu, 29 September 2011 07:00 By: ric90
Query tuning oracle 9i By: sathik on Tue, 27 September 2011	6	546	Wed, 28 September 2011 03:25 By: Flyby
SQL with more parse 11g By: gkrishn on Tue, 27 September 2011	6	342	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	486	Thu, 22 September 2011 13:12 By: BlackSwan
Performance Issue Oracle 10g, Windows XP By: a_oracle on Wed, 21 September 2011	9	5424	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	2282	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	784	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	418	Fri, 16 September 2011 14:26 By: varunvir
session_cached_cursors 11gr2 By: fairdaus on Mon, 27 June 2011	11	3007	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	587	Thu, 15 September 2011 20:27 By: BlackSwan
"NOT IN" REPLACE WITH "MINUS" Oracle 10gR2 By: thinknightgmailcom on Thu, 15 September 2011	2	716	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	644	Tue, 13 September 2011 08:29 By: cookiemonster
pl/sql oracle 10g By: zodiacsom on Wed, 07 September 2011	24	775	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	1189	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	704	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	595	Fri, 09 September 2011 07:37 By: Michel Cadot
Performance issue Oracle 10g, wondows XP By: a_oracle on Tue, 06 September 2011	4	505	Fri, 09 September 2011 04:00 By: msol25
how we can match variable sga using v$sga and v$sgastat views Oracle Database 10g Enterprise Edition Release 10.2.0.4.0 - 64bi By: msol25 on Fri, 02 September 2011	10	1268	Thu, 08 September 2011 08:05 By: Michel Cadot
Stopping optimizer choosing concatenation Oracle9i Enterprise Edition Release 9.2.0.8.0 - 64bit Production By: Roachcoach on Wed, 07 September 2011	2	484	Wed, 07 September 2011 07:42 By: Roachcoach
Statspack unit information Oracle database, Standard 10.0.2.4, Windows 2003 By: Flyby on Tue, 06 September 2011	2	734	Tue, 06 September 2011 14:19 By: Flyby
RANGE SCAN VS FAST FULL SCAN By: patneel on Mon, 29 August 2011	4	2203	Mon, 05 September 2011 07:09 By: msol25