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
Performance tuning By: avrillavinge on Fri, 27 March 2009	4	3045	Fri, 27 March 2009 04:57 By: avrillavinge
Tkprof trace file meaning Oracel10g By: sr_orcl on Thu, 26 March 2009	3	3207	Thu, 26 March 2009 09:53 By: BlackSwan
statspack error By: somavamshi on Fri, 20 July 2007	7	7912	Tue, 24 March 2009 10:49 By: BlackSwan
Performance tuning Oracle By: sivakumar.rj on Mon, 23 March 2009	2	2555	Tue, 24 March 2009 08:40 By: JRowbottom
Optimizing the query 10.2.0.3.0 By: user71408 on Mon, 23 March 2009	7	2689	Tue, 24 March 2009 07:31 By: JRowbottom
optimisation of queries oracle 10g By: rajasekhar857 on Tue, 24 March 2009	3	2442	Tue, 24 March 2009 06:25 By: cookiemonster
rownum slowing query 11g By: psk1 on Wed, 18 March 2009	14	12968	Mon, 23 March 2009 05:50 By: Alessandro Rossi
query problem (merged 4) By: shoowaruno on Fri, 20 March 2009	4	2887	Sun, 22 March 2009 09:48 By: BlackSwan
No difference in plan and cost for IN and EXISTS Oracle 10.2.0.1.0 By: mbmalasenthil on Thu, 19 March 2009	6	3570	Sat, 21 March 2009 01:19 By: Michel Cadot
Slowness Problem when logging in by tool Oracle sql developer Oracle 10g 10.2.0.3.0 on linux 64 bit By: MIFI on Fri, 13 February 2009	1	3514	Thu, 19 March 2009 19:53 By: oraxperts
show parameter session (merged) By: dirish on Wed, 11 March 2009	7	5983	Thu, 19 March 2009 19:50 By: oraxperts
which index is faster oracle 10g By: grpatwari on Wed, 11 March 2009	7	4105	Thu, 19 March 2009 05:29 By: jayanta.senapati
Is there any way to rebuilds indexes online in Oracle SE !! Oracle 11g By: AlinaC on Wed, 18 March 2009	1	2010	Wed, 18 March 2009 18:43 By: BlackSwan
Query perfomance Oracle 10 g By: gkrishn on Wed, 18 March 2009	5	3263	Wed, 18 March 2009 11:15 By: Mahesh Rajendran
How to release the un-used INDEX space, which were created by DELETE Oracle9i Release 9.2.0.4.0 By: tapaskmanna on Wed, 11 March 2009	8	3977	Sat, 14 March 2009 19:36 By: Mahesh Rajendran
TNS-12518: TNS:listener could not hand off client connection inbound connection timed out (ORA-3136) By: oraclevijay on Thu, 12 March 2009	2	5444	Sat, 14 March 2009 09:20 By: alexzeng
Issue of Space as Data is growing Rapidly. racle 9.2.0.4.0 Database By: tapaskmanna on Wed, 11 March 2009	3	2359	Thu, 12 March 2009 04:41 By: Michel Cadot
BITMAP CONVERSION FROM/TO ROWIDS 10g Enterprise Edition Release 10.2.0.1.0 By: mbmalasenthil on Wed, 11 March 2009	2	4853	Wed, 11 March 2009 21:05 By: rleishman
Effective SQL Oracle 10G By: stvel on Tue, 10 March 2009	1	2252	Tue, 10 March 2009 07:40 By: Michel Cadot
Oracle Performance Tuning of a view Oracle version 9.2.0.1.0 By: manoj12 on Fri, 06 March 2009	4	3951	Sat, 07 March 2009 09:31 By: BlackSwan
Changes to the query Oracle 10.2.0.1.0 By: mbmalasenthil on Fri, 06 March 2009	3	2401	Sat, 07 March 2009 09:03 By: alexzeng
PLSQL Query Tuning Suggestion/Feedback needed Oracle 10G By: bahubcd on Fri, 06 March 2009	4	3877	Sat, 07 March 2009 08:59 By: alexzeng
IOT secondary indexes SLOW performance 9i, hp-ux By: sky_lt on Tue, 17 February 2009	23	8271	Fri, 06 March 2009 05:19 By: sky_lt
Hash Joins and Memory Requirements By: scottwmackey on Mon, 02 March 2009	11	4787	Fri, 06 March 2009 01:40 By: alexzeng
updation of 200millions rows Oracle, 10.2.0.3, AIX 5.3 ML9 By: junaidsystems on Fri, 27 February 2009	17	4510	Wed, 04 March 2009 08:45 By: JRowbottom
Difference between cost and %CPU? Oracle 10g By: mbmalasenthil on Sat, 28 February 2009	12	3992	Tue, 03 March 2009 15:33 By: Mahesh Rajendran
Indexes (merged 3) By: danyromimd on Tue, 03 March 2009	8	3663	Tue, 03 March 2009 11:51 By: Michel Cadot
Package Tuning using Bulk Excpetion oracle10g By: sr_orcl on Mon, 02 March 2009	2	2744	Tue, 03 March 2009 06:45 By: JRowbottom
Package Tuning (merged 4) By: sr_orcl on Wed, 25 February 2009	9	4045	Mon, 02 March 2009 08:50 By: BlackSwan
Oracle 9i sga advisory view By: jrmtl on Sun, 01 March 2009	5	4642	Mon, 02 March 2009 08:02 By: JRowbottom
Understanding Explain Plan 10g By: ehegagoka on Wed, 20 August 2008	6	6479	Mon, 02 March 2009 03:07 By: oyaryn
Tuning analytical function query oracle 10g By: ajitpal.s on Thu, 26 February 2009	12	5142	Fri, 27 February 2009 06:28 By: ajitpal.s
better way to write or tune a query with joins By: abs_amit on Tue, 24 February 2009	3	3156	Thu, 26 February 2009 14:59 By: rleishman
unable to reduce the cost of the query Oracle 10G /Linux By: dhanamukesh on Wed, 25 February 2009	4	2483	Thu, 26 February 2009 07:26 By: babuknb
Subpartitions number Oracle 10.2G By: wakula on Tue, 13 January 2009	15	10409	Thu, 26 February 2009 04:13 By: wakula
cardinality in bitmap index Oracle 9.2.0.6.0 By: saurabhshukla on Wed, 25 February 2009	3	4910	Thu, 26 February 2009 03:18 By: saurabhshukla
Joining Oracle Text results with multiple tables / Performance Problems Oracle 9i, Win Server 2003 By: ltnuke on Thu, 27 March 2008	9	12569	Wed, 25 February 2009 22:55 By: Barbara Boehmer
blevel in bitmap index Oracle 9.2.0.5.0, AIX 5.3.0.0 By: saurabhshukla on Tue, 24 February 2009	1	2765	Wed, 25 February 2009 03:44 By: babuknb
Modifying a plan Oracle 10g By: Olivia on Tue, 24 February 2009	3	2272	Tue, 24 February 2009 04:14 By: Olivia
SQL tuning (merged) By: cherry on Sat, 21 February 2009	5	3818	Mon, 23 February 2009 22:42 By: cherry