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
Related To STATSPACK By: raj_roshan_009 on Mon, 09 June 2008	1	1938	Mon, 09 June 2008 05:18 By: Michel Cadot
Scheduled jobs Oracle 10g By: balaji1482 on Sun, 08 June 2008	5	1518	Mon, 09 June 2008 04:41 By: Michel Cadot
Parallel hint 10g By: beetel on Sun, 08 June 2008	3	8703	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	1624	Mon, 09 June 2008 03:04 By: Michel Cadot
Partitioning decision Oracle 9i By: nishantstpl on Sat, 07 June 2008	2	1222	Sat, 07 June 2008 09:26 By: Michel Cadot
How to understand query plan By: Manoj.Gupta.91 on Fri, 06 June 2008	3	1611	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	1580	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	1206	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	1298	Thu, 05 June 2008 06:49 By: Mahesh Rajendran
Please help in tuning Oracle 10g By: mukundsahare on Thu, 22 May 2008	15	4184	Thu, 05 June 2008 05:21 By: Michel Cadot
How to perforamnce this query? Help By: balaji23_d on Wed, 04 June 2008	4	1804	Thu, 05 June 2008 02:55 By: JRowbottom
How to improve this query oracle 10g By: ravi214u on Thu, 05 June 2008	1	1377	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	1523	Wed, 04 June 2008 17:18 By: coleing
Performance issue with Oracle Cluster By: sarwagya on Wed, 04 June 2008	5	2128	Wed, 04 June 2008 07:09 By: Michel Cadot
View Performance tunning DB2 By: ravi214u on Wed, 04 June 2008	2	1352	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	4565	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	1895	Fri, 30 May 2008 04:54 By: hristo
Tuning need for a large data oracle 10G By: gyankr on Thu, 29 May 2008	2	1391	Thu, 29 May 2008 22:21 By: rleishman
optimizer_index_cost_adj oracle9i By: shrinika on Tue, 27 May 2008	3	1604	Wed, 28 May 2008 09:44 By: shrinika
performance issue By: manoj12 on Fri, 23 May 2008	23	3818	Wed, 28 May 2008 00:08 By: manoj12
SQL STATEMENT TUNING ORACLE 8I By: chinmayikkalki on Wed, 14 May 2008	10	2604	Tue, 27 May 2008 19:03 By: rleishman
using sequences in dml By: gyankr on Mon, 26 May 2008	2	1552	Tue, 27 May 2008 09:25 By: Kevin Meade
Network Load Oracle 10g By: virmahi on Fri, 23 May 2008	2	1294	Tue, 27 May 2008 00:43 By: virmahi
b-tree index of partitioned tabl 10g By: beetel on Sun, 25 May 2008	7	2007	Mon, 26 May 2008 22:57 By: Michel Cadot
optimizer path via DBLINKS By: gilou28 on Fri, 23 May 2008	2	1770	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	2291	Fri, 23 May 2008 23:47 By: rajatratewal
New to Tuning By: srini_thiru on Fri, 23 May 2008	2	1915	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	1418	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	1295	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	2387	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	7955	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	1844	Thu, 22 May 2008 20:51 By: harrysmall3
DMT oracle 9i, Windows XP By: sdhanuka on Thu, 22 May 2008	11	1969	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	4816	Thu, 22 May 2008 07:48 By: rleishman
Performance issue By: manoj12 on Thu, 22 May 2008	3	1603	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	3857	Wed, 21 May 2008 22:47 By: BlackSwan
Finding HWM oracle9i By: shrinika on Tue, 20 May 2008	4	1551	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	1946	Wed, 21 May 2008 05:54 By: rleishman
MView Complete Refresh Performance Issue Oracle 10g R2 Enterprise Edition 64-bit, Windows 2003 Standard Edition 64-bit By: sawcna on Wed, 21 May 2008	1	1372	Wed, 21 May 2008 05:53 By: rleishman
Updates ( 1 2) By: Lucky A on Sun, 11 May 2008	53	4925	Wed, 21 May 2008 01:30 By: Lucky A