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	6808	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	4552	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	7702	Thu, 13 August 2009 03:18 By: JRowbottom
Performance issue in Plsql oracle10g By: bond007 on Sat, 08 August 2009	2	2311	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	2456	Sat, 08 August 2009 21:01 By: rleishman
Hard parse in RAC 10.2.0.4 By: serenaender on Fri, 07 August 2009	0	7968	Fri, 07 August 2009 03:28 By: serenaender
Need help to tune the query By: oraappsfaq on Wed, 05 August 2009	14	8295	Thu, 06 August 2009 15:08 By: Michel Cadot
Block Corruption Oracle 9204, XP By: saharookiedba on Thu, 06 August 2009	1	2347	Thu, 06 August 2009 11:23 By: BlackSwan
Temp Size 10.2.0.3 By: maheshmhs on Thu, 06 August 2009	5	2019	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	6225	Wed, 05 August 2009 16:39 By: serenaender
FTS - Full Table Scan - (merged 3) By: satish2130 on Wed, 05 August 2009	9	5105	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	2523	Tue, 04 August 2009 05:28 By: virmahi
regarding statspack.... By: balavignesh on Wed, 13 April 2005	12	23238	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	2910	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	5066	Sun, 02 August 2009 04:43 By: rleishman
How to optimize this plan (merged) By: prachij593 on Thu, 30 July 2009	8	2380	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	6249	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	2974	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	3168	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	8031	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	5140	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	3032	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	3758	Tue, 28 July 2009 09:37 By: Alessandro Rossi
sqlarea sql oracle 10.2.0.3 By: prachij593 on Tue, 28 July 2009	2	1860	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	3902	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	3073	Mon, 27 July 2009 05:59 By: cookiemonster
Funtion Tuning Oracle 9204, XP By: saharookiedba on Fri, 24 July 2009	3	1681	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	1975	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	1975	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	7793	Thu, 23 July 2009 04:17 By: JRowbottom
SQL tuning Oracle, 10gR2, Linux 5.2 By: ivpraveen on Wed, 22 July 2009	4	2461	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	1682	Thu, 23 July 2009 01:12 By: Michel Cadot
Storage parameters.. Oralce 10g. By: venkat_bollu on Fri, 26 June 2009	9	4902	Wed, 22 July 2009 04:34 By: rleishman
Problem with query having order by , distinct clause By: vikram1780 on Sun, 21 June 2009	5	3859	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	3165	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	10085	Thu, 16 July 2009 07:05 By: prachij593
To Tune or To use Hints (merged) By: ap_karthi on Wed, 15 July 2009	4	2587	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	4713	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	1948	Fri, 10 July 2009 01:45 By: Michel Cadot
Performance question Oracle9.2.0.3 By: Olivia on Tue, 07 July 2009	3	1850	Thu, 09 July 2009 15:40 By: coleing