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
Optimizing the query 10.2.0.3.0 By: user71408 on Mon, 23 March 2009	7	2138	Tue, 24 March 2009 07:31 By: JRowbottom
optimisation of queries oracle 10g By: rajasekhar857 on Tue, 24 March 2009	3	1989	Tue, 24 March 2009 06:25 By: cookiemonster
rownum slowing query 11g By: psk1 on Wed, 18 March 2009	14	11583	Mon, 23 March 2009 05:50 By: Alessandro Rossi
query problem (merged 4) By: shoowaruno on Fri, 20 March 2009	4	1752	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	2911	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	2929	Thu, 19 March 2009 19:53 By: oraxperts
show parameter session (merged) By: dirish on Wed, 11 March 2009	7	5296	Thu, 19 March 2009 19:50 By: oraxperts
which index is faster oracle 10g By: grpatwari on Wed, 11 March 2009	7	2469	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	1335	Wed, 18 March 2009 18:43 By: BlackSwan
Query perfomance Oracle 10 g By: gkrishn on Wed, 18 March 2009	5	1855	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	2676	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	4807	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	1703	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	4446	Wed, 11 March 2009 21:05 By: rleishman
Effective SQL Oracle 10G By: stvel on Tue, 10 March 2009	1	1526	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	3303	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	1915	Sat, 07 March 2009 09:03 By: alexzeng
PLSQL Query Tuning Suggestion/Feedback needed Oracle 10G By: bahubcd on Fri, 06 March 2009	4	3181	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	6913	Fri, 06 March 2009 05:19 By: sky_lt
Hash Joins and Memory Requirements By: scottwmackey on Mon, 02 March 2009	11	3921	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	3415	Wed, 04 March 2009 08:45 By: JRowbottom
Difference between cost and %CPU? Oracle 10g By: mbmalasenthil on Sat, 28 February 2009	12	3143	Tue, 03 March 2009 15:33 By: Mahesh Rajendran
Indexes (merged 3) By: danyromimd on Tue, 03 March 2009	8	1910	Tue, 03 March 2009 11:51 By: Michel Cadot
Package Tuning using Bulk Excpetion oracle10g By: sr_orcl on Mon, 02 March 2009	2	1760	Tue, 03 March 2009 06:45 By: JRowbottom
Package Tuning (merged 4) By: sr_orcl on Wed, 25 February 2009	9	3323	Mon, 02 March 2009 08:50 By: BlackSwan
Oracle 9i sga advisory view By: jrmtl on Sun, 01 March 2009	5	4078	Mon, 02 March 2009 08:02 By: JRowbottom
Understanding Explain Plan 10g By: ehegagoka on Wed, 20 August 2008	6	5890	Mon, 02 March 2009 03:07 By: oyaryn
Tuning analytical function query oracle 10g By: ajitpal.s on Thu, 26 February 2009	12	4371	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	2067	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	1823	Thu, 26 February 2009 07:26 By: babuknb
Subpartitions number Oracle 10.2G By: wakula on Tue, 13 January 2009	15	9031	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	3736	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	11879	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	2257	Wed, 25 February 2009 03:44 By: babuknb
Modifying a plan Oracle 10g By: Olivia on Tue, 24 February 2009	3	1766	Tue, 24 February 2009 04:14 By: Olivia
SQL tuning (merged) By: cherry on Sat, 21 February 2009	5	3274	Mon, 23 February 2009 22:42 By: cherry
Inconsistent performance in database Oracle 10g By: prashas_d on Thu, 19 February 2009	6	4518	Mon, 23 February 2009 22:25 By: BlackSwan
tuning Oracle10g By: sr_orcl on Sun, 22 February 2009	1	1299	Sun, 22 February 2009 22:33 By: BlackSwan
Index usage By: deepak samal on Fri, 20 February 2009	2	1676	Fri, 20 February 2009 21:19 By: rleishman
Execution Plan (merged) By: Brayan on Tue, 17 February 2009	22	5238	Fri, 20 February 2009 21:13 By: rleishman