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	3270	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	9018	Mon, 30 June 2008 12:47 By: BlackSwan
SQL tuning Oracle 9.2 By: chintu00 on Thu, 26 June 2008	13	3252	Mon, 30 June 2008 12:08 By: Kriptas
Tuning a query 9i By: mohamed_eliyas on Mon, 30 June 2008	2	1289	Mon, 30 June 2008 11:41 By: Michel Cadot
increase of sessions Oracle 8.1.7 By: darcioreine on Mon, 30 June 2008	0	6256	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	1888	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	1782	Sat, 28 June 2008 15:21 By: Kriptas
Segment Tuning --- TablePartition 10g, solaris By: visva4u3 on Sun, 22 June 2008	2	10078	Sat, 28 June 2008 15:19 By: Kriptas
Optimize this query.. 10g By: beetel on Fri, 06 June 2008	8	2245	Sat, 28 June 2008 15:12 By: Kriptas
Long running SQL needs tuning Oracle 10g By: hidnana on Fri, 13 June 2008	4	1932	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	2935	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	3530	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	4634	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	1761	Wed, 25 June 2008 08:43 By: JRowbottom
Window Sort By: ArvindBhope on Wed, 25 June 2008	9	6176	Wed, 25 June 2008 06:34 By: Michel Cadot
How tuning this query ? (merged) By: mm_kanish05 on Tue, 24 June 2008	7	1899	Wed, 25 June 2008 02:54 By: rleishman
max number of users and sessions oracle,solaris By: sheldon1982 on Tue, 24 June 2008	4	1450	Tue, 24 June 2008 07:59 By: sheldon1982
Tuning for Queuing (merged) By: kumar1234 on Sun, 22 June 2008	7	2238	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	1686	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	2159	Mon, 23 June 2008 13:55 By: Kevin Meade
Soft Close Cursor 9i and 10g By: ehegagoka on Tue, 17 June 2008	3	1706	Mon, 23 June 2008 13:50 By: Kevin Meade
Explain Plan By: ArvindBhope on Sat, 21 June 2008	8	1721	Sun, 22 June 2008 12:21 By: BlackSwan
slow server windows 2000 By: alister on Sun, 15 June 2008	12	2220	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	11268	Wed, 18 June 2008 22:37 By: rleishman
Hit Rate. Oracle10g, Windows 2003 By: weekend79 on Wed, 18 June 2008	1	1320	Wed, 18 June 2008 10:27 By: Michel Cadot
SQL Tune Oracle 9i By: ankitmodicse on Wed, 18 June 2008	1	1965	Wed, 18 June 2008 06:10 By: Michel Cadot
Performance issues Oracle 9i ,SunT2000 By: vaishalikatarki on Tue, 13 May 2008	3	2220	Tue, 17 June 2008 03:29 By: alanm
Need help in tuning this procedure By: victory_nag on Mon, 16 June 2008	7	2035	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	2122	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	6388	Tue, 17 June 2008 00:53 By: Michel Cadot
Partitioning a table in Source 10g By: beetel on Tue, 10 June 2008	2	1321	Mon, 16 June 2008 23:29 By: Michel Cadot
Performance1 Oracle 9i By: manoj12 on Tue, 10 June 2008	10	2228	Mon, 16 June 2008 15:25 By: JackyShu
Performance improvement measures Oracle 9i By: nishantstpl on Mon, 16 June 2008	1	1331	Mon, 16 June 2008 10:37 By: BlackSwan
SQL Needs to be tuned Oracle 10g By: virmahi on Thu, 05 June 2008	7	3866	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	1674	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	1994	Fri, 13 June 2008 00:17 By: skumar.dba
diskreads/executions By: bm50793 on Thu, 12 June 2008	2	2055	Thu, 12 June 2008 03:18 By: bm50793
explain plan By: bm50793 on Tue, 10 June 2008	1	1174	Tue, 10 June 2008 06:20 By: Michel Cadot
About tkprof By: raj_roshan_009 on Tue, 10 June 2008	3	1381	Tue, 10 June 2008 03:12 By: Michel Cadot
BITMAP INDEX By: bm50793 on Thu, 05 June 2008	7	1967	Mon, 09 June 2008 15:51 By: JackyShu