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
About tkprof By: raj_roshan_009 on Tue, 10 June 2008	3	1619	Tue, 10 June 2008 03:12 By: Michel Cadot
BITMAP INDEX By: bm50793 on Thu, 05 June 2008	7	2216	Mon, 09 June 2008 15:51 By: JackyShu
Related To STATSPACK By: raj_roshan_009 on Mon, 09 June 2008	1	2153	Mon, 09 June 2008 05:18 By: Michel Cadot
Scheduled jobs Oracle 10g By: balaji1482 on Sun, 08 June 2008	5	1809	Mon, 09 June 2008 04:41 By: Michel Cadot
Parallel hint 10g By: beetel on Sun, 08 June 2008	3	9008	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	1857	Mon, 09 June 2008 03:04 By: Michel Cadot
Partitioning decision Oracle 9i By: nishantstpl on Sat, 07 June 2008	2	1449	Sat, 07 June 2008 09:26 By: Michel Cadot
How to understand query plan By: Manoj.Gupta.91 on Fri, 06 June 2008	3	1954	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	1832	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	1490	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	1516	Thu, 05 June 2008 06:49 By: Mahesh Rajendran
Please help in tuning Oracle 10g By: mukundsahare on Thu, 22 May 2008	15	4690	Thu, 05 June 2008 05:21 By: Michel Cadot
How to perforamnce this query? Help By: balaji23_d on Wed, 04 June 2008	4	2124	Thu, 05 June 2008 02:55 By: JRowbottom
How to improve this query oracle 10g By: ravi214u on Thu, 05 June 2008	1	1636	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	1791	Wed, 04 June 2008 17:18 By: coleing
Performance issue with Oracle Cluster By: sarwagya on Wed, 04 June 2008	5	2486	Wed, 04 June 2008 07:09 By: Michel Cadot
View Performance tunning DB2 By: ravi214u on Wed, 04 June 2008	2	1630	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	5475	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	2161	Fri, 30 May 2008 04:54 By: hristo
Tuning need for a large data oracle 10G By: gyankr on Thu, 29 May 2008	2	1641	Thu, 29 May 2008 22:21 By: rleishman
optimizer_index_cost_adj oracle9i By: shrinika on Tue, 27 May 2008	3	2209	Wed, 28 May 2008 09:44 By: shrinika
performance issue By: manoj12 on Fri, 23 May 2008	23	4340	Wed, 28 May 2008 00:08 By: manoj12
SQL STATEMENT TUNING ORACLE 8I By: chinmayikkalki on Wed, 14 May 2008	10	2967	Tue, 27 May 2008 19:03 By: rleishman
using sequences in dml By: gyankr on Mon, 26 May 2008	2	2061	Tue, 27 May 2008 09:25 By: Kevin Meade
Network Load Oracle 10g By: virmahi on Fri, 23 May 2008	2	1926	Tue, 27 May 2008 00:43 By: virmahi
b-tree index of partitioned tabl 10g By: beetel on Sun, 25 May 2008	7	2513	Mon, 26 May 2008 22:57 By: Michel Cadot
optimizer path via DBLINKS By: gilou28 on Fri, 23 May 2008	2	2007	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	2688	Fri, 23 May 2008 23:47 By: rajatratewal
New to Tuning By: srini_thiru on Fri, 23 May 2008	2	2138	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	1639	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	1652	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	2732	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	9668	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	2728	Thu, 22 May 2008 20:51 By: harrysmall3
DMT oracle 9i, Windows XP By: sdhanuka on Thu, 22 May 2008	11	2532	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	5133	Thu, 22 May 2008 07:48 By: rleishman
Performance issue By: manoj12 on Thu, 22 May 2008	3	1900	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	4208	Wed, 21 May 2008 22:47 By: BlackSwan
Finding HWM oracle9i By: shrinika on Tue, 20 May 2008	4	2295	Wed, 21 May 2008 07:06 By: shrinika
Query is taking exceptionally large amount of time Oracle Database 10g Enterprise Edition Release 10.1.0.4.0,PL/SQL Release 10.1.0.4.0 By: sreenadhaj on Tue, 20 May 2008	5	2470	Wed, 21 May 2008 05:54 By: rleishman