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
Blocking Session - blocked SQL -> SELECT SYSDATE FROM SYS.DUAL Oracle 10.0.0.4g, Windows 2003 By: kkxenon on Tue, 11 August 2009	8	6817	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	4560	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	7709	Thu, 13 August 2009 03:18 By: JRowbottom
Performance issue in Plsql oracle10g By: bond007 on Sat, 08 August 2009	2	2317	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	2460	Sat, 08 August 2009 21:01 By: rleishman
Hard parse in RAC 10.2.0.4 By: serenaender on Fri, 07 August 2009	0	7974	Fri, 07 August 2009 03:28 By: serenaender
Need help to tune the query By: oraappsfaq on Wed, 05 August 2009	14	8302	Thu, 06 August 2009 15:08 By: Michel Cadot
Block Corruption Oracle 9204, XP By: saharookiedba on Thu, 06 August 2009	1	2351	Thu, 06 August 2009 11:23 By: BlackSwan
Temp Size 10.2.0.3 By: maheshmhs on Thu, 06 August 2009	5	2025	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	6231	Wed, 05 August 2009 16:39 By: serenaender
FTS - Full Table Scan - (merged 3) By: satish2130 on Wed, 05 August 2009	9	5115	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	2529	Tue, 04 August 2009 05:28 By: virmahi
regarding statspack.... By: balavignesh on Wed, 13 April 2005	12	23254	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	2916	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	5069	Sun, 02 August 2009 04:43 By: rleishman
How to optimize this plan (merged) By: prachij593 on Thu, 30 July 2009	8	2385	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	6257	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	2980	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	3176	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	8042	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	5146	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	3039	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	3762	Tue, 28 July 2009 09:37 By: Alessandro Rossi
sqlarea sql oracle 10.2.0.3 By: prachij593 on Tue, 28 July 2009	2	1866	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	3908	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	3083	Mon, 27 July 2009 05:59 By: cookiemonster
Funtion Tuning Oracle 9204, XP By: saharookiedba on Fri, 24 July 2009	3	1684	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	1981	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	1979	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	7815	Thu, 23 July 2009 04:17 By: JRowbottom
SQL tuning Oracle, 10gR2, Linux 5.2 By: ivpraveen on Wed, 22 July 2009	4	2465	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	1688	Thu, 23 July 2009 01:12 By: Michel Cadot
Storage parameters.. Oralce 10g. By: venkat_bollu on Fri, 26 June 2009	9	4914	Wed, 22 July 2009 04:34 By: rleishman
Problem with query having order by , distinct clause By: vikram1780 on Sun, 21 June 2009	5	3865	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	3169	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	10092	Thu, 16 July 2009 07:05 By: prachij593
To Tune or To use Hints (merged) By: ap_karthi on Wed, 15 July 2009	4	2592	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	4722	Sun, 12 July 2009 10:33 By: Michel Cadot
Redo Size doesn't increase more than 260MB HP-UX 11.23, Oracle 9.2i By: dongyoon.ka on Fri, 10 July 2009	1	1957	Fri, 10 July 2009 01:45 By: Michel Cadot
Performance question Oracle9.2.0.3 By: Olivia on Tue, 07 July 2009	3	1855	Thu, 09 July 2009 15:40 By: coleing