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
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	6195	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	1354	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	2099	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	1806	Mon, 05 September 2011 02:45 By: Michel Cadot
performance tuning oracle 10g By: zodiacsom on Fri, 02 September 2011	2	1352	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	2993	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	2428	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	2808	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	1331	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	1814	Tue, 30 August 2011 01:27 By: jai_subi
harsh area size and sort area size By: matthew00 on Mon, 29 August 2011	3	1884	Mon, 29 August 2011 11:38 By: John Watson
Interface table design question Oracle, 10g By: ironman12 on Sat, 27 August 2011	5	2712	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	3317	Mon, 29 August 2011 06:17 By: kesavansundaram
RANGE SCAN VS FAST FULL SCAN By: patneel on Mon, 29 August 2011	3	4918	Mon, 29 August 2011 05:36 By: Michel Cadot
SQL TUNING Oracle 10G By: Bhaskarquadrant on Fri, 26 August 2011	7	1951	Sun, 28 August 2011 22:23 By: hkchital
Managing Large Table Oracle 10g By: EbenT on Fri, 26 August 2011	7	3077	Sun, 28 August 2011 20:56 By: Kevin Meade
SGA_TARGET and shared pool By: matthew00 on Thu, 25 August 2011	2	1668	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	2140	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	2530	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	5803	Wed, 24 August 2011 19:57 By: Kevin Meade
application performance By: matthew00 on Wed, 24 August 2011	1	1130	Wed, 24 August 2011 17:51 By: cookiemonster
Speed up this SQL Oracle 10g By: r23rob on Fri, 19 August 2011	2	2035	Mon, 22 August 2011 08:16 By: rleishman
performance tuning PROBLEM By: shashank_kurasrediffmail on Thu, 18 August 2011	8	3617	Thu, 18 August 2011 11:17 By: BlackSwan
Need help with tuning By: naveenreddy on Wed, 17 August 2011	1	1276	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	1892	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	2868	Wed, 17 August 2011 02:34 By: a_oracle
Oracle Instance Related Query Oracle 10g By: saswatic on Tue, 16 August 2011	2	1860	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	12286	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	3317	Thu, 11 August 2011 13:36 By: SSharma
Performance tuning for select statement By: benjamin.tl on Fri, 15 January 2010	19	5203	Thu, 11 August 2011 03:33 By: cookiemonster
New Trace File Oracle 11g R1 By: rchenna on Thu, 11 August 2011	3	2079	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	18051	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	9764	Wed, 10 August 2011 22:32 By: BlackSwan
Simple SQL with High Concurrency Wait Time (cursor: pin S wait on X) Oracle 10gR2 on AIX 6.1 By: eclipsis on Fri, 05 August 2011	18	14212	Tue, 09 August 2011 06:46 By: LNossov
Application slow Oracle 11.1.0.7.0, Unix-HP By: Smith14 on Sun, 07 August 2011	4	2401	Sun, 07 August 2011 12:20 By: Michel Cadot
PERFORMANCE TUNING By: shashank_kurasrediffmail on Sat, 06 August 2011	1	2242	Sat, 06 August 2011 10:02 By: Michel Cadot
How to reduce the consistent gets of this sql Oracle 10.2.0.4.0 64bit , AIX 5.3 ( 1 2) By: snowball on Mon, 27 June 2011	72	9247	Wed, 03 August 2011 20:34 By: snowball
enq: TS - contention 10.2.0.4 By: varunvir on Tue, 26 July 2011	14	32527	Mon, 01 August 2011 07:27 By: LNossov
PERFORMANCE HIT DUE TO NVL FUNCTION Oracle 9i By: Fasy on Fri, 29 July 2011	1	2513	Fri, 29 July 2011 07:34 By: Michel Cadot
BitMap Index Issue By: abdulrahaman288 on Thu, 21 July 2011	6	2820	Mon, 25 July 2011 22:00 By: rleishman