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
The column name in user_ind_colums shows a SYS_ name when function based index created 10g By: DRDBA on Mon, 30 June 2008	2	3257	Mon, 30 June 2008 13:58 By: DRDBA
reduce the wait event for db file sequential read event Oracle 10g By: ankush_chawla on Mon, 30 June 2008	6	9006	Mon, 30 June 2008 12:47 By: BlackSwan
SQL tuning Oracle 9.2 By: chintu00 on Thu, 26 June 2008	13	3242	Mon, 30 June 2008 12:08 By: Kriptas
Tuning a query 9i By: mohamed_eliyas on Mon, 30 June 2008	2	1283	Mon, 30 June 2008 11:41 By: Michel Cadot
increase of sessions Oracle 8.1.7 By: darcioreine on Mon, 30 June 2008	0	6250	Mon, 30 June 2008 09:44 By: darcioreine
Query is taking more time to execute Oracle 10G, Actuate reports By: sreenadhaj on Mon, 16 June 2008	3	1880	Sun, 29 June 2008 23:23 By: sreenadhaj
to make fast retrival oracle 10g, xp By: sd_md_rizwan@yahoo.com on Mon, 16 June 2008	3	1775	Sat, 28 June 2008 15:21 By: Kriptas
Segment Tuning --- TablePartition 10g, solaris By: visva4u3 on Sun, 22 June 2008	2	10068	Sat, 28 June 2008 15:19 By: Kriptas
Optimize this query.. 10g By: beetel on Fri, 06 June 2008	8	2236	Sat, 28 June 2008 15:12 By: Kriptas
Long running SQL needs tuning Oracle 10g By: hidnana on Fri, 13 June 2008	4	1926	Sat, 28 June 2008 15:03 By: Kriptas
performance of database , please help oracle 9i, 9.2.0.1, windows By: seema.taunk on Tue, 24 June 2008	7	2923	Fri, 27 June 2008 12:53 By: michael_bialik
Unable to Understand Explain Plan Oracle 10g, red hat By: ultimatejiten on Wed, 18 June 2008	18	3520	Fri, 27 June 2008 08:22 By: Michel Cadot
Tuning the query - Not using the index 9.2.0.7.0 By: Brayan on Tue, 24 June 2008	12	4626	Thu, 26 June 2008 05:08 By: Brayan
High Frequency of Redo Log Files Oracle 8.1.7.0 By: pune01 on Wed, 25 June 2008	3	1752	Wed, 25 June 2008 08:43 By: JRowbottom
Window Sort By: ArvindBhope on Wed, 25 June 2008	9	6170	Wed, 25 June 2008 06:34 By: Michel Cadot
How tuning this query ? (merged) By: mm_kanish05 on Tue, 24 June 2008	7	1891	Wed, 25 June 2008 02:54 By: rleishman
max number of users and sessions oracle,solaris By: sheldon1982 on Tue, 24 June 2008	4	1445	Tue, 24 June 2008 07:59 By: sheldon1982
Tuning for Queuing (merged) By: kumar1234 on Sun, 22 June 2008	7	2231	Tue, 24 June 2008 01:33 By: Michel Cadot
Please help to Tuning Please help to Tuning By: bagulia_pilla on Tue, 24 June 2008	4	1676	Tue, 24 June 2008 01:32 By: Michel Cadot
Capturing top 10 longest running SQLs Oracle Enterprise RDBMS server 8.1.7.4 By: wkk1020 on Wed, 18 June 2008	5	2152	Mon, 23 June 2008 13:55 By: Kevin Meade
Soft Close Cursor 9i and 10g By: ehegagoka on Tue, 17 June 2008	3	1699	Mon, 23 June 2008 13:50 By: Kevin Meade
Explain Plan By: ArvindBhope on Sat, 21 June 2008	8	1717	Sun, 22 June 2008 12:21 By: BlackSwan
slow server windows 2000 By: alister on Sun, 15 June 2008	12	2212	Wed, 18 June 2008 23:09 By: alister
Self join removal Oracle, 9.2.0.4, Windows XP By: srihari.gurram on Tue, 06 May 2008	16	11258	Wed, 18 June 2008 22:37 By: rleishman
Hit Rate. Oracle10g, Windows 2003 By: weekend79 on Wed, 18 June 2008	1	1314	Wed, 18 June 2008 10:27 By: Michel Cadot
SQL Tune Oracle 9i By: ankitmodicse on Wed, 18 June 2008	1	1958	Wed, 18 June 2008 06:10 By: Michel Cadot
Performance issues Oracle 9i ,SunT2000 By: vaishalikatarki on Tue, 13 May 2008	3	2215	Tue, 17 June 2008 03:29 By: alanm
Need help in tuning this procedure By: victory_nag on Mon, 16 June 2008	7	2026	Tue, 17 June 2008 02:27 By: flyboy
Extents and blocks Oracle 10.2.0.3.0, Solaris By: aslamkhalife on Thu, 12 June 2008	10	2109	Tue, 17 June 2008 01:08 By: aslamkhalife
regarding sql_id value in awr report oracle 10.2.0.3 solaris 10 64bit By: skumar.dba on Thu, 12 June 2008	5	6381	Tue, 17 June 2008 00:53 By: Michel Cadot
Partitioning a table in Source 10g By: beetel on Tue, 10 June 2008	2	1316	Mon, 16 June 2008 23:29 By: Michel Cadot
Performance1 Oracle 9i By: manoj12 on Tue, 10 June 2008	10	2219	Mon, 16 June 2008 15:25 By: JackyShu
Performance improvement measures Oracle 9i By: nishantstpl on Mon, 16 June 2008	1	1322	Mon, 16 June 2008 10:37 By: BlackSwan
SQL Needs to be tuned Oracle 10g By: virmahi on Thu, 05 June 2008	7	3856	Sun, 15 June 2008 23:06 By: rajatratewal
delete statement is causing lot of performance hurt in DB oracle 10.2.0.2 solaris 10 By: skumar.dba on Fri, 06 June 2008	3	1666	Fri, 13 June 2008 12:28 By: Kevin Meade
sessions were hung for long time oracle 10.2.0.3 solaris 10 64bit By: skumar.dba on Thu, 12 June 2008	6	1987	Fri, 13 June 2008 00:17 By: skumar.dba
diskreads/executions By: bm50793 on Thu, 12 June 2008	2	2049	Thu, 12 June 2008 03:18 By: bm50793
explain plan By: bm50793 on Tue, 10 June 2008	1	1165	Tue, 10 June 2008 06:20 By: Michel Cadot
About tkprof By: raj_roshan_009 on Tue, 10 June 2008	3	1373	Tue, 10 June 2008 03:12 By: Michel Cadot
BITMAP INDEX By: bm50793 on Thu, 05 June 2008	7	1959	Mon, 09 June 2008 15:51 By: JackyShu