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
don't know why this baseline doesn't work :/ 11.2.0.1.0 By: piotrtal on Fri, 16 September 2011	3	709	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	592	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	730	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	966	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	1670	Thu, 29 September 2011 07:00 By: ric90
Query tuning oracle 9i By: sathik on Tue, 27 September 2011	6	649	Wed, 28 September 2011 03:25 By: Flyby
SQL with more parse 11g By: gkrishn on Tue, 27 September 2011	6	384	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	613	Thu, 22 September 2011 13:12 By: BlackSwan
Performance Issue Oracle 10g, Windows XP By: a_oracle on Wed, 21 September 2011	9	5698	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	2477	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	958	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	500	Fri, 16 September 2011 14:26 By: varunvir
session_cached_cursors 11gr2 By: fairdaus on Mon, 27 June 2011	11	4665	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	696	Thu, 15 September 2011 20:27 By: BlackSwan
"NOT IN" REPLACE WITH "MINUS" Oracle 10gR2 By: thinknightgmailcom on Thu, 15 September 2011	2	775	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	796	Tue, 13 September 2011 08:29 By: cookiemonster
pl/sql oracle 10g By: zodiacsom on Wed, 07 September 2011	24	863	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	1274	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	753	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	648	Fri, 09 September 2011 07:37 By: Michel Cadot
Performance issue Oracle 10g, wondows XP By: a_oracle on Tue, 06 September 2011	4	586	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	1852	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	549	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	813	Tue, 06 September 2011 14:19 By: Flyby
RANGE SCAN VS FAST FULL SCAN By: patneel on Mon, 29 August 2011	4	2594	Mon, 05 September 2011 07:09 By: msol25
dml is very slowly when table have many rows 11.2.0.1.0 Windos XP By: andy huang on Sun, 04 September 2011	6	549	Mon, 05 September 2011 02:45 By: Michel Cadot
performance tuning oracle 10g By: zodiacsom on Fri, 02 September 2011	2	507	Fri, 02 September 2011 13:15 By: flyboy
Query Performance Issue (4 Merged) Oracle 10 G By: mani_rbs on Wed, 31 August 2011	9	746	Fri, 02 September 2011 09:33 By: BlackSwan
Oracle Database 10g Enterprise Edition Release 10.2.0.4.0 - 64bi how we can match variable sga in v$sga with v$sgastat view By: msol25 on Fri, 02 September 2011	5	1120	Fri, 02 September 2011 05:25 By: Michel Cadot
Memory Fault Error in Tkprof Oracle 10g, Unix By: artisteprasanna on Wed, 31 August 2011	1	1445	Wed, 31 August 2011 23:56 By: BlackSwan
Importing Partitioning rows from Many Export Files. oracle version 10g Windows XP By: muktha_22 on Tue, 30 August 2011	2	405	Tue, 30 August 2011 02:40 By: muktha_22
different between move and shink table 11g windows By: andy huang on Fri, 22 July 2011	2	895	Tue, 30 August 2011 01:27 By: jai_subi
harsh area size and sort area size By: matthew00 on Mon, 29 August 2011	3	545	Mon, 29 August 2011 11:38 By: John Watson
Interface table design question Oracle, 10g By: ironman12 on Sat, 27 August 2011	5	587	Mon, 29 August 2011 11:21 By: Kevin Meade
Need to improve speed for UPDATE statement oracle 11.2.0.1.0 linux 2.6 By: kesavansundaram on Mon, 29 August 2011	0	2013	Mon, 29 August 2011 06:17 By: kesavansundaram
SQL TUNING Oracle 10G By: Bhaskarquadrant on Fri, 26 August 2011	7	509	Sun, 28 August 2011 22:23 By: hkchital
Managing Large Table Oracle 10g By: EbenT on Fri, 26 August 2011	7	796	Sun, 28 August 2011 20:56 By: Kevin Meade
SGA_TARGET and shared pool By: matthew00 on Thu, 25 August 2011	2	824	Thu, 25 August 2011 15:24 By: John Watson
performance doubt 11.2.0.2.0 By: shashank_kurasrediffmail on Thu, 11 August 2011	9	559	Thu, 25 August 2011 07:45 By: Kevin Meade
Insert / Update Performance due to Triggers (merged 2) Oracle 9i By: mjm22 on Wed, 10 August 2011	5	856	Wed, 24 August 2011 20:41 By: Kevin Meade