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
free command 10.2.0.4 By: mafc73 on Wed, 02 July 2008	3	1972	Thu, 03 July 2008 08:53 By: BlackSwan
Query running slow oracle,10202,AIX By: areeb on Tue, 01 July 2008	1	2971	Tue, 01 July 2008 13:39 By: BlackSwan
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	3767	Tue, 01 July 2008 07:25 By: alanm
Best way to partition my table By: kjcamann@gmail.com on Sun, 29 June 2008	7	4634	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	3949	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	10198	Mon, 30 June 2008 12:47 By: BlackSwan
SQL tuning Oracle 9.2 By: chintu00 on Thu, 26 June 2008	13	4171	Mon, 30 June 2008 12:08 By: Kriptas
Tuning a query 9i By: mohamed_eliyas on Mon, 30 June 2008	2	2145	Mon, 30 June 2008 11:41 By: Michel Cadot
increase of sessions Oracle 8.1.7 By: darcioreine on Mon, 30 June 2008	0	6770	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	2717	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	2682	Sat, 28 June 2008 15:21 By: Kriptas
Segment Tuning --- TablePartition 10g, solaris By: visva4u3 on Sun, 22 June 2008	2	11051	Sat, 28 June 2008 15:19 By: Kriptas
Optimize this query.. 10g By: beetel on Fri, 06 June 2008	8	3040	Sat, 28 June 2008 15:12 By: Kriptas
Long running SQL needs tuning Oracle 10g By: hidnana on Fri, 13 June 2008	4	2593	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	4387	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	4971	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	5731	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	3014	Wed, 25 June 2008 08:43 By: JRowbottom
Window Sort By: ArvindBhope on Wed, 25 June 2008	9	7672	Wed, 25 June 2008 06:34 By: Michel Cadot
How tuning this query ? (merged) By: mm_kanish05 on Tue, 24 June 2008	7	2710	Wed, 25 June 2008 02:54 By: rleishman
max number of users and sessions oracle,solaris By: sheldon1982 on Tue, 24 June 2008	4	2705	Tue, 24 June 2008 07:59 By: sheldon1982
Tuning for Queuing (merged) By: kumar1234 on Sun, 22 June 2008	7	3277	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	2326	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	2871	Mon, 23 June 2008 13:55 By: Kevin Meade
Soft Close Cursor 9i and 10g By: ehegagoka on Tue, 17 June 2008	3	2443	Mon, 23 June 2008 13:50 By: Kevin Meade
Explain Plan By: ArvindBhope on Sat, 21 June 2008	8	3093	Sun, 22 June 2008 12:21 By: BlackSwan
slow server windows 2000 By: alister on Sun, 15 June 2008	12	3321	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	12593	Wed, 18 June 2008 22:37 By: rleishman
Hit Rate. Oracle10g, Windows 2003 By: weekend79 on Wed, 18 June 2008	1	2004	Wed, 18 June 2008 10:27 By: Michel Cadot
SQL Tune Oracle 9i By: ankitmodicse on Wed, 18 June 2008	1	2640	Wed, 18 June 2008 06:10 By: Michel Cadot
Performance issues Oracle 9i ,SunT2000 By: vaishalikatarki on Tue, 13 May 2008	3	2816	Tue, 17 June 2008 03:29 By: alanm
Need help in tuning this procedure By: victory_nag on Mon, 16 June 2008	7	2865	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	3897	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	7134	Tue, 17 June 2008 00:53 By: Michel Cadot
Partitioning a table in Source 10g By: beetel on Tue, 10 June 2008	2	2092	Mon, 16 June 2008 23:29 By: Michel Cadot
Performance1 Oracle 9i By: manoj12 on Tue, 10 June 2008	10	3054	Mon, 16 June 2008 15:25 By: JackyShu
Performance improvement measures Oracle 9i By: nishantstpl on Mon, 16 June 2008	1	1896	Mon, 16 June 2008 10:37 By: BlackSwan
SQL Needs to be tuned Oracle 10g By: virmahi on Thu, 05 June 2008	7	4818	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	2274	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	2902	Fri, 13 June 2008 00:17 By: skumar.dba