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
multiple dbwr processes and multiple archver process Oracle 9.0.2.0.6 Windows Server 2003 By: M.Shakeel Azeem on Fri, 11 January 2008	3	3496	Tue, 01 July 2008 07:25 By: alanm
Best way to partition my table By: kjcamann@gmail.com on Sun, 29 June 2008	7	4068	Mon, 30 June 2008 23:34 By: rleishman
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	3709	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	9729	Mon, 30 June 2008 12:47 By: BlackSwan
SQL tuning Oracle 9.2 By: chintu00 on Thu, 26 June 2008	13	3625	Mon, 30 June 2008 12:08 By: Kriptas
Tuning a query 9i By: mohamed_eliyas on Mon, 30 June 2008	2	1892	Mon, 30 June 2008 11:41 By: Michel Cadot
increase of sessions Oracle 8.1.7 By: darcioreine on Mon, 30 June 2008	0	6626	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	2440	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	2407	Sat, 28 June 2008 15:21 By: Kriptas
Segment Tuning --- TablePartition 10g, solaris By: visva4u3 on Sun, 22 June 2008	2	10690	Sat, 28 June 2008 15:19 By: Kriptas
Optimize this query.. 10g By: beetel on Fri, 06 June 2008	8	2600	Sat, 28 June 2008 15:12 By: Kriptas
Long running SQL needs tuning Oracle 10g By: hidnana on Fri, 13 June 2008	4	2254	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	3970	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	4191	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	5220	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	2594	Wed, 25 June 2008 08:43 By: JRowbottom
Window Sort By: ArvindBhope on Wed, 25 June 2008	9	7224	Wed, 25 June 2008 06:34 By: Michel Cadot
How tuning this query ? (merged) By: mm_kanish05 on Tue, 24 June 2008	7	2328	Wed, 25 June 2008 02:54 By: rleishman
max number of users and sessions oracle,solaris By: sheldon1982 on Tue, 24 June 2008	4	2416	Tue, 24 June 2008 07:59 By: sheldon1982
Tuning for Queuing (merged) By: kumar1234 on Sun, 22 June 2008	7	2892	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	2089	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	2509	Mon, 23 June 2008 13:55 By: Kevin Meade
Soft Close Cursor 9i and 10g By: ehegagoka on Tue, 17 June 2008	3	2054	Mon, 23 June 2008 13:50 By: Kevin Meade
Explain Plan By: ArvindBhope on Sat, 21 June 2008	8	2674	Sun, 22 June 2008 12:21 By: BlackSwan
slow server windows 2000 By: alister on Sun, 15 June 2008	12	2759	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	11931	Wed, 18 June 2008 22:37 By: rleishman
Hit Rate. Oracle10g, Windows 2003 By: weekend79 on Wed, 18 June 2008	1	1820	Wed, 18 June 2008 10:27 By: Michel Cadot
SQL Tune Oracle 9i By: ankitmodicse on Wed, 18 June 2008	1	2422	Wed, 18 June 2008 06:10 By: Michel Cadot
Performance issues Oracle 9i ,SunT2000 By: vaishalikatarki on Tue, 13 May 2008	3	2453	Tue, 17 June 2008 03:29 By: alanm
Need help in tuning this procedure By: victory_nag on Mon, 16 June 2008	7	2409	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	3242	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	6758	Tue, 17 June 2008 00:53 By: Michel Cadot
Partitioning a table in Source 10g By: beetel on Tue, 10 June 2008	2	1779	Mon, 16 June 2008 23:29 By: Michel Cadot
Performance1 Oracle 9i By: manoj12 on Tue, 10 June 2008	10	2596	Mon, 16 June 2008 15:25 By: JackyShu
Performance improvement measures Oracle 9i By: nishantstpl on Mon, 16 June 2008	1	1713	Mon, 16 June 2008 10:37 By: BlackSwan
SQL Needs to be tuned Oracle 10g By: virmahi on Thu, 05 June 2008	7	4326	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	1989	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	2464	Fri, 13 June 2008 00:17 By: skumar.dba
diskreads/executions By: bm50793 on Thu, 12 June 2008	2	2552	Thu, 12 June 2008 03:18 By: bm50793
explain plan By: bm50793 on Tue, 10 June 2008	1	1640	Tue, 10 June 2008 06:20 By: Michel Cadot