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
diskreads/executions By: bm50793 on Thu, 12 June 2008	2	2788	Thu, 12 June 2008 03:18 By: bm50793
explain plan By: bm50793 on Tue, 10 June 2008	1	1834	Tue, 10 June 2008 06:20 By: Michel Cadot
About tkprof By: raj_roshan_009 on Tue, 10 June 2008	3	1910	Tue, 10 June 2008 03:12 By: Michel Cadot
BITMAP INDEX By: bm50793 on Thu, 05 June 2008	7	2528	Mon, 09 June 2008 15:51 By: JackyShu
Related To STATSPACK By: raj_roshan_009 on Mon, 09 June 2008	1	2363	Mon, 09 June 2008 05:18 By: Michel Cadot
Scheduled jobs Oracle 10g By: balaji1482 on Sun, 08 June 2008	5	2148	Mon, 09 June 2008 04:41 By: Michel Cadot
Parallel hint 10g By: beetel on Sun, 08 June 2008	3	9357	Mon, 09 June 2008 04:20 By: Michel Cadot
increase the Oracle datafile size or add another datafile Oracle By: arunmdr on Mon, 09 June 2008	1	2085	Mon, 09 June 2008 03:04 By: Michel Cadot
Partitioning decision Oracle 9i By: nishantstpl on Sat, 07 June 2008	2	1686	Sat, 07 June 2008 09:26 By: Michel Cadot
How to understand query plan By: Manoj.Gupta.91 on Fri, 06 June 2008	3	2378	Fri, 06 June 2008 06:23 By: rajatratewal
query takes so much time to update oracle 9i By: tannad on Fri, 06 June 2008	2	2073	Fri, 06 June 2008 05:45 By: JRowbottom
Question on Object Statistics and Query Execution RDBMS, 9.2.0.6, Solaris 2.8 By: bnienhau on Thu, 05 June 2008	2	1795	Thu, 05 June 2008 12:24 By: bnienhau
Index Monitoring 9.2.0.6.0 IBM AIX By: pokhraj_das on Thu, 05 June 2008	1	1725	Thu, 05 June 2008 06:49 By: Mahesh Rajendran
Please help in tuning Oracle 10g By: mukundsahare on Thu, 22 May 2008	15	5424	Thu, 05 June 2008 05:21 By: Michel Cadot
How to perforamnce this query? Help By: balaji23_d on Wed, 04 June 2008	4	2560	Thu, 05 June 2008 02:55 By: JRowbottom
How to improve this query oracle 10g By: ravi214u on Thu, 05 June 2008	1	1852	Thu, 05 June 2008 01:52 By: Michel Cadot
query is taking index sacn,even though it is taking long time and it is not completing oracle 10.2.0.2 solaris 10 64 bit By: skumar.dba on Wed, 04 June 2008	2	2025	Wed, 04 June 2008 17:18 By: coleing
Performance issue with Oracle Cluster By: sarwagya on Wed, 04 June 2008	5	2936	Wed, 04 June 2008 07:09 By: Michel Cadot
View Performance tunning DB2 By: ravi214u on Wed, 04 June 2008	2	1841	Wed, 04 June 2008 00:44 By: Michel Cadot
difference between db block gets and consistent gets (merged) By: reena_ch30 on Wed, 18 October 2006	24	6831	Tue, 03 June 2008 06:19 By: shrinika
Metric Critical Alert - should I care? oracle 10g unix By: alzuma on Mon, 19 May 2008	1	2435	Fri, 30 May 2008 04:54 By: hristo
Tuning need for a large data oracle 10G By: gyankr on Thu, 29 May 2008	2	1874	Thu, 29 May 2008 22:21 By: rleishman
optimizer_index_cost_adj oracle9i By: shrinika on Tue, 27 May 2008	3	2481	Wed, 28 May 2008 09:44 By: shrinika
performance issue By: manoj12 on Fri, 23 May 2008	23	5000	Wed, 28 May 2008 00:08 By: manoj12
SQL STATEMENT TUNING ORACLE 8I By: chinmayikkalki on Wed, 14 May 2008	10	3390	Tue, 27 May 2008 19:03 By: rleishman
using sequences in dml By: gyankr on Mon, 26 May 2008	2	2404	Tue, 27 May 2008 09:25 By: Kevin Meade
Network Load Oracle 10g By: virmahi on Fri, 23 May 2008	2	2197	Tue, 27 May 2008 00:43 By: virmahi
b-tree index of partitioned tabl 10g By: beetel on Sun, 25 May 2008	7	2992	Mon, 26 May 2008 22:57 By: Michel Cadot
optimizer path via DBLINKS By: gilou28 on Fri, 23 May 2008	2	2306	Sat, 24 May 2008 03:55 By: coleing
Conditions On Virtual Columns Degrades Performance Oracle 9i,9.2.0.6.0,XP By: rajatratewal on Fri, 23 May 2008	8	3132	Fri, 23 May 2008 23:47 By: rajatratewal
New to Tuning By: srini_thiru on Fri, 23 May 2008	2	2412	Fri, 23 May 2008 10:51 By: Michel Cadot
batch job that run long Oracle 9.2 By: chintu00 on Thu, 22 May 2008	2	1857	Fri, 23 May 2008 05:26 By: rleishman
What situation should I add more termporary tablespace? Solaris 9 + oracle10gR2 RAC By: wxfjordan on Fri, 23 May 2008	3	1893	Fri, 23 May 2008 04:24 By: Michel Cadot
deletion taking longer time Oracle 10g,win xp By: swas_fly on Fri, 16 May 2008	6	3042	Thu, 22 May 2008 22:20 By: BlackSwan
Incorrect optimizer_index_caching affect on plan optimization Oracle 9.2, Unix platform By: harrysmall3 on Thu, 01 May 2008	16	10521	Thu, 22 May 2008 21:43 By: harrysmall3
Difference in performance of a SQL Query for same execution plan Oracle 10g By: amorphous4u on Tue, 20 May 2008	8	3106	Thu, 22 May 2008 20:51 By: harrysmall3
DMT oracle 9i, Windows XP By: sdhanuka on Thu, 22 May 2008	11	3027	Thu, 22 May 2008 12:43 By: sdhanuka
Query taking 10 seconds to fetch only 300 records Oracle 9i By: virmahi on Thu, 22 May 2008	5	5454	Thu, 22 May 2008 07:48 By: rleishman
Performance issue By: manoj12 on Thu, 22 May 2008	3	2311	Thu, 22 May 2008 04:05 By: Michel Cadot
Oracle partition doesn't work for select which scans entire table Oracle10gEE,10.2.0.1.0, RHEL4 By: bbmonster on Wed, 21 May 2008	4	4493	Wed, 21 May 2008 22:47 By: BlackSwan