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
session_cached_cursors 11gr2 By: fairdaus on Mon, 27 June 2011	11	21587	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	3195	Thu, 15 September 2011 20:27 By: BlackSwan
"NOT IN" REPLACE WITH "MINUS" Oracle 10gR2 By: thinknightgmailcom on Thu, 15 September 2011	1	2696	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	5338	Tue, 13 September 2011 08:29 By: cookiemonster
pl/sql oracle 10g By: zodiacsom on Wed, 07 September 2011	24	5915	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	7503	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	4662	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	2856	Fri, 09 September 2011 07:37 By: Michel Cadot
Performance issue Oracle 10g, wondows XP By: a_oracle on Tue, 06 September 2011	3	2677	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	8160	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	2598	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	3200	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	3817	Mon, 05 September 2011 02:45 By: Michel Cadot
performance tuning oracle 10g By: zodiacsom on Fri, 02 September 2011	2	2691	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	4388	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	3701	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	4266	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	2484	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	3071	Tue, 30 August 2011 01:27 By: jai_subi
harsh area size and sort area size By: matthew00 on Mon, 29 August 2011	3	3207	Mon, 29 August 2011 11:38 By: John Watson
Interface table design question Oracle, 10g By: ironman12 on Sat, 27 August 2011	5	4441	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	4313	Mon, 29 August 2011 06:17 By: kesavansundaram
RANGE SCAN VS FAST FULL SCAN By: patneel on Mon, 29 August 2011	3	6161	Mon, 29 August 2011 05:36 By: Michel Cadot
SQL TUNING Oracle 10G By: Bhaskarquadrant on Fri, 26 August 2011	7	3233	Sun, 28 August 2011 22:23 By: hkchital
Managing Large Table Oracle 10g By: EbenT on Fri, 26 August 2011	7	4513	Sun, 28 August 2011 20:56 By: Kevin Meade
SGA_TARGET and shared pool By: matthew00 on Thu, 25 August 2011	2	3103	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	3612	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	3875	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	7208	Wed, 24 August 2011 19:57 By: Kevin Meade
application performance By: matthew00 on Wed, 24 August 2011	1	2460	Wed, 24 August 2011 17:51 By: cookiemonster
Speed up this SQL Oracle 10g By: r23rob on Fri, 19 August 2011	2	3015	Mon, 22 August 2011 08:16 By: rleishman
performance tuning PROBLEM By: shashank_kurasrediffmail on Thu, 18 August 2011	8	4971	Thu, 18 August 2011 11:17 By: BlackSwan
Need help with tuning By: naveenreddy on Wed, 17 August 2011	1	2426	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	3085	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	3990	Wed, 17 August 2011 02:34 By: a_oracle
Oracle Instance Related Query Oracle 10g By: saswatic on Tue, 16 August 2011	2	3100	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	15097	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	4689	Thu, 11 August 2011 13:36 By: SSharma
Performance tuning for select statement By: benjamin.tl on Fri, 15 January 2010	19	7273	Thu, 11 August 2011 03:33 By: cookiemonster
New Trace File Oracle 11g R1 By: rchenna on Thu, 11 August 2011	3	3696	Thu, 11 August 2011 01:33 By: Michel Cadot