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
Open cursor count is too high Oracle 10.2.0.4, Solaris 9 By: dasuwal@gmail.com on Tue, 18 August 2009	5	7149	Wed, 19 August 2009 00:24 By: trantuananh24hg
Virtual Memory Paging Oracle 10.2.0.4g Windows Server 2003 EE By: kkxenon on Sun, 16 August 2009	1	7283	Sun, 16 August 2009 17:38 By: BlackSwan
Blocking Session - blocked SQL -> SELECT SYSDATE FROM SYS.DUAL Oracle 10.0.0.4g, Windows 2003 By: kkxenon on Tue, 11 August 2009	8	8754	Fri, 14 August 2009 09:14 By: BlackSwan
Impact of table partitioning on DML/Index creation Time (merged) By: niteshsabharwal on Tue, 11 August 2009	7	5571	Thu, 13 August 2009 09:10 By: BlackSwan
ORA-600 and ORA-7445 error in Oracle 10g R2 Oracle 10g R2 ,OS - 2003 Server, RAM 4GB, Front End-JAVA By: suvin_prathab on Tue, 04 August 2009	4	8881	Thu, 13 August 2009 03:18 By: JRowbottom
Performance issue in Plsql oracle10g By: bond007 on Sat, 08 August 2009	2	3330	Sat, 08 August 2009 21:08 By: rleishman
Parallelism disabled in data warehouse Oracle 9.2 on unix By: goo321 on Fri, 07 August 2009	3	2887	Sat, 08 August 2009 21:01 By: rleishman
Hard parse in RAC 10.2.0.4 By: serenaender on Fri, 07 August 2009	0	8380	Fri, 07 August 2009 03:28 By: serenaender
Need help to tune the query By: oraappsfaq on Wed, 05 August 2009	14	8894	Thu, 06 August 2009 15:08 By: Michel Cadot
Block Corruption Oracle 9204, XP By: saharookiedba on Thu, 06 August 2009	1	2780	Thu, 06 August 2009 11:23 By: BlackSwan
Temp Size 10.2.0.3 By: maheshmhs on Thu, 06 August 2009	5	3066	Thu, 06 August 2009 05:00 By: Michel Cadot
A high value of Rollback per Transaction (97,74%) 10.2.0.4.0 RAC By: alekons on Wed, 29 July 2009	11	6819	Wed, 05 August 2009 16:39 By: serenaender
FTS - Full Table Scan - (merged 3) By: satish2130 on Wed, 05 August 2009	9	6507	Wed, 05 August 2009 08:29 By: Michel Cadot
Selection/Updation from a table based on condition Oracle 10g By: virmahi on Sun, 24 May 2009	4	2908	Tue, 04 August 2009 05:28 By: virmahi
regarding statspack.... By: balavignesh on Wed, 13 April 2005	12	24149	Mon, 03 August 2009 01:57 By: SameerChoudhari
Oracle Performance Issue with dbms_stats.gather_table_stats Oracle 9i By: draculla on Sun, 02 August 2009	1	3535	Sun, 02 August 2009 05:29 By: Michel Cadot
How To Eliminate Sort Unique Oracle 10.1.0.2.0 HP-UX By: vinniora on Fri, 31 July 2009	3	5471	Sun, 02 August 2009 04:43 By: rleishman
How to optimize this plan (merged) By: prachij593 on Thu, 30 July 2009	8	2776	Sat, 01 August 2009 10:44 By: amardeep.sidhu
Recompute plan each time for the sql oracle 10.2.0.3 By: prachij593 on Mon, 27 July 2009	15	6940	Fri, 31 July 2009 00:47 By: Kevin Meade
Bind variables and SGA size Oracle, Any, Any By: lharpf on Thu, 30 July 2009	4	3925	Fri, 31 July 2009 00:34 By: lharpf
Erratic explain plan 10.1.0.4.0, 64 bit By: cherry on Wed, 29 July 2009	9	3811	Thu, 30 July 2009 03:14 By: cookiemonster
Negative Tablespace Free Space value Oracle, 10.2.0, Windows Server 2003 By: Gert Willemsens on Tue, 28 July 2009	12	8980	Thu, 30 July 2009 02:24 By: Michel Cadot
performance issue oracle 10g RAC Oracle 10g RAC with ASM Windows Server 2003 By: marcobain on Tue, 14 July 2009	8	6956	Wed, 29 July 2009 14:18 By: t.velayutham@gmail.com
Rollback segment too small error oracle10g By: deepbans on Tue, 28 July 2009	9	3693	Wed, 29 July 2009 00:13 By: deepbans
No parallel DML with IOTs oracle 10.2.0.3 By: prachij593 on Tue, 28 July 2009	2	4326	Tue, 28 July 2009 09:37 By: Alessandro Rossi
sqlarea sql oracle 10.2.0.3 By: prachij593 on Tue, 28 July 2009	2	2160	Tue, 28 July 2009 07:23 By: prachij593
Different plan for same sql oracle 10.2.0.3 By: prachij593 on Wed, 22 July 2009	10	4392	Mon, 27 July 2009 09:23 By: Alessandro Rossi
Response time is high in 10g Oracle10.2.0.3 By: prachij593 on Sun, 26 July 2009	7	3649	Mon, 27 July 2009 05:59 By: cookiemonster
Funtion Tuning Oracle 9204, XP By: saharookiedba on Fri, 24 July 2009	3	2164	Sat, 25 July 2009 06:23 By: michael_bialik
Index with OR predicates Oracle 9.2.0.3 By: prachij593 on Tue, 07 July 2009	4	2504	Fri, 24 July 2009 02:09 By: prachij593
How to avoid Full table scan for Like '%XYZ%' Oracle 9.2.0.3 By: prachij593 on Wed, 01 July 2009	2	2447	Thu, 23 July 2009 16:53 By: Kevin Meade
Viewing Pinned Objects in KEEP cache 9.2.0.7 By: Brayan on Mon, 20 July 2009	14	8598	Thu, 23 July 2009 04:17 By: JRowbottom
SQL tuning Oracle, 10gR2, Linux 5.2 By: ivpraveen on Wed, 22 July 2009	4	2914	Thu, 23 July 2009 03:47 By: ivpraveen
Parse And Executing Statements Oracle 10.1.0.2.0,HP-UX B.11.23 By: vinniora on Thu, 23 July 2009	1	2228	Thu, 23 July 2009 01:12 By: Michel Cadot
Storage parameters.. Oralce 10g. By: venkat_bollu on Fri, 26 June 2009	9	5342	Wed, 22 July 2009 04:34 By: rleishman
Problem with query having order by , distinct clause By: vikram1780 on Sun, 21 June 2009	5	4336	Sun, 19 July 2009 00:39 By: saptarshibasu
Select with no conditions taking long time, too many blocks, pctused Oracle 9.2.0.8 Solaris By: goo321 on Thu, 16 July 2009	9	3786	Sat, 18 July 2009 06:55 By: goo321
Force the optimizer to use the primary key index Oracle 10g, Win XP By: ashoka_bl on Thu, 09 July 2009	21	10921	Thu, 16 July 2009 07:05 By: prachij593
To Tune or To use Hints (merged) By: ap_karthi on Wed, 15 July 2009	4	3103	Wed, 15 July 2009 23:20 By: Michel Cadot
Enable 10053 Trace information Oracle 10g, Win XP By: ashoka_bl on Sun, 12 July 2009	7	5177	Sun, 12 July 2009 10:33 By: Michel Cadot