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
"NOT IN" REPLACE WITH "MINUS" Oracle 10gR2 By: thinknightgmailcom on Thu, 15 September 2011	1	2536	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	4902	Tue, 13 September 2011 08:29 By: cookiemonster
pl/sql oracle 10g By: zodiacsom on Wed, 07 September 2011	24	5354	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	7055	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	4434	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	2685	Fri, 09 September 2011 07:37 By: Michel Cadot
Performance issue Oracle 10g, wondows XP By: a_oracle on Tue, 06 September 2011	3	2517	Fri, 09 September 2011 03:56 By: cookiemonster
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	7738	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	2420	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	3031	Tue, 06 September 2011 14:19 By: Flyby
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	3597	Mon, 05 September 2011 02:45 By: Michel Cadot
performance tuning oracle 10g By: zodiacsom on Fri, 02 September 2011	2	2465	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	4081	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	3463	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	4134	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	2361	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	2919	Tue, 30 August 2011 01:27 By: jai_subi
harsh area size and sort area size By: matthew00 on Mon, 29 August 2011	3	3051	Mon, 29 August 2011 11:38 By: John Watson
Interface table design question Oracle, 10g By: ironman12 on Sat, 27 August 2011	5	4193	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	4204	Mon, 29 August 2011 06:17 By: kesavansundaram
RANGE SCAN VS FAST FULL SCAN By: patneel on Mon, 29 August 2011	3	5987	Mon, 29 August 2011 05:36 By: Michel Cadot
SQL TUNING Oracle 10G By: Bhaskarquadrant on Fri, 26 August 2011	7	3020	Sun, 28 August 2011 22:23 By: hkchital
Managing Large Table Oracle 10g By: EbenT on Fri, 26 August 2011	7	4199	Sun, 28 August 2011 20:56 By: Kevin Meade
SGA_TARGET and shared pool By: matthew00 on Thu, 25 August 2011	2	2963	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	3322	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	3650	Wed, 24 August 2011 20:41 By: Kevin Meade
how expensive is unique versus primary key in large table 9.2.0.1.0 By: OraFerro on Mon, 15 August 2011	5	6959	Wed, 24 August 2011 19:57 By: Kevin Meade
application performance By: matthew00 on Wed, 24 August 2011	1	2323	Wed, 24 August 2011 17:51 By: cookiemonster
Speed up this SQL Oracle 10g By: r23rob on Fri, 19 August 2011	2	2884	Mon, 22 August 2011 08:16 By: rleishman
performance tuning PROBLEM By: shashank_kurasrediffmail on Thu, 18 August 2011	8	4754	Thu, 18 August 2011 11:17 By: BlackSwan
Need help with tuning By: naveenreddy on Wed, 17 August 2011	1	2270	Wed, 17 August 2011 14:20 By: Michel Cadot
2 design alternatives, passing natural key as meaningful foreign key 9.2.0.1.0 By: OraFerro on Wed, 17 August 2011	5	2876	Wed, 17 August 2011 03:01 By: Michel Cadot
Query sub-factoring issue Oracle 10g,Windows XP By: a_oracle on Wed, 17 August 2011	4	3812	Wed, 17 August 2011 02:34 By: a_oracle
Oracle Instance Related Query Oracle 10g By: saswatic on Tue, 16 August 2011	2	2959	Wed, 17 August 2011 00:47 By: John Watson
start with and connect by Oracle 11g R2 , RHEL4 By: liliek on Mon, 25 July 2011	28	14505	Mon, 15 August 2011 01:39 By: liliek
Need to decrease the cost as much as possible Version: Oracle 10.2.0.3.0 OS: Solaris By: SSharma on Fri, 29 July 2011	11	4443	Thu, 11 August 2011 13:36 By: SSharma
Performance tuning for select statement By: benjamin.tl on Fri, 15 January 2010	19	6838	Thu, 11 August 2011 03:33 By: cookiemonster
New Trace File Oracle 11g R1 By: rchenna on Thu, 11 August 2011	3	3489	Thu, 11 August 2011 01:33 By: Michel Cadot
nvl problem i think 11.2.0.2.0 By: shashank_kurasrediffmail on Wed, 10 August 2011	30	19869	Wed, 10 August 2011 22:45 By: shashank_kurasrediffmail
SGA_MAX_SIZE to more than 2G? 10.2.0.1.0, OS=Windows 2003 server 64 bit with 16G RAM By: pt12340 on Wed, 10 August 2011	6	10943	Wed, 10 August 2011 22:32 By: BlackSwan