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	3465	Tue, 01 July 2008 07:25 By: alanm
Best way to partition my table By: kjcamann@gmail.com on Sun, 29 June 2008	7	4029	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	3701	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	9715	Mon, 30 June 2008 12:47 By: BlackSwan
SQL tuning Oracle 9.2 By: chintu00 on Thu, 26 June 2008	13	3616	Mon, 30 June 2008 12:08 By: Kriptas
Tuning a query 9i By: mohamed_eliyas on Mon, 30 June 2008	2	1889	Mon, 30 June 2008 11:41 By: Michel Cadot
increase of sessions Oracle 8.1.7 By: darcioreine on Mon, 30 June 2008	0	6620	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	2433	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	2391	Sat, 28 June 2008 15:21 By: Kriptas
Segment Tuning --- TablePartition 10g, solaris By: visva4u3 on Sun, 22 June 2008	2	10676	Sat, 28 June 2008 15:19 By: Kriptas
Optimize this query.. 10g By: beetel on Fri, 06 June 2008	8	2588	Sat, 28 June 2008 15:12 By: Kriptas
Long running SQL needs tuning Oracle 10g By: hidnana on Fri, 13 June 2008	4	2248	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	3954	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	4080	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	5201	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	2580	Wed, 25 June 2008 08:43 By: JRowbottom
Window Sort By: ArvindBhope on Wed, 25 June 2008	9	7212	Wed, 25 June 2008 06:34 By: Michel Cadot
How tuning this query ? (merged) By: mm_kanish05 on Tue, 24 June 2008	7	2316	Wed, 25 June 2008 02:54 By: rleishman
max number of users and sessions oracle,solaris By: sheldon1982 on Tue, 24 June 2008	4	2408	Tue, 24 June 2008 07:59 By: sheldon1982
Tuning for Queuing (merged) By: kumar1234 on Sun, 22 June 2008	7	2886	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	2073	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	2495	Mon, 23 June 2008 13:55 By: Kevin Meade
Soft Close Cursor 9i and 10g By: ehegagoka on Tue, 17 June 2008	3	2024	Mon, 23 June 2008 13:50 By: Kevin Meade
Explain Plan By: ArvindBhope on Sat, 21 June 2008	8	2609	Sun, 22 June 2008 12:21 By: BlackSwan
slow server windows 2000 By: alister on Sun, 15 June 2008	12	2743	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	11895	Wed, 18 June 2008 22:37 By: rleishman
Hit Rate. Oracle10g, Windows 2003 By: weekend79 on Wed, 18 June 2008	1	1817	Wed, 18 June 2008 10:27 By: Michel Cadot
SQL Tune Oracle 9i By: ankitmodicse on Wed, 18 June 2008	1	2418	Wed, 18 June 2008 06:10 By: Michel Cadot
Performance issues Oracle 9i ,SunT2000 By: vaishalikatarki on Tue, 13 May 2008	3	2444	Tue, 17 June 2008 03:29 By: alanm
Need help in tuning this procedure By: victory_nag on Mon, 16 June 2008	7	2400	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	3216	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	6692	Tue, 17 June 2008 00:53 By: Michel Cadot
Partitioning a table in Source 10g By: beetel on Tue, 10 June 2008	2	1768	Mon, 16 June 2008 23:29 By: Michel Cadot
Performance1 Oracle 9i By: manoj12 on Tue, 10 June 2008	10	2574	Mon, 16 June 2008 15:25 By: JackyShu
Performance improvement measures Oracle 9i By: nishantstpl on Mon, 16 June 2008	1	1708	Mon, 16 June 2008 10:37 By: BlackSwan
SQL Needs to be tuned Oracle 10g By: virmahi on Thu, 05 June 2008	7	4291	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	1952	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	2451	Fri, 13 June 2008 00:17 By: skumar.dba
diskreads/executions By: bm50793 on Thu, 12 June 2008	2	2533	Thu, 12 June 2008 03:18 By: bm50793
explain plan By: bm50793 on Tue, 10 June 2008	1	1634	Tue, 10 June 2008 06:20 By: Michel Cadot