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
How to find Bind variable values from Raw Trace file? Oracle 10.2.0.3.0 on Red Hat Linux By: orasaket on Wed, 27 August 2008	2	3714	Wed, 27 August 2008 11:30 By: orasaket
Does it mean Explain plan? Oracle9i By: Olivia on Tue, 26 August 2008	7	4395	Wed, 27 August 2008 04:33 By: Michel Cadot
Row Chaining problem 10.2.0.3 By: sudhir1582 on Wed, 27 August 2008	1	1520	Wed, 27 August 2008 04:29 By: JRowbottom
Dead lock oracle 9.2.0.7 ,windows server 2003 By: jayarajkrishna on Fri, 22 August 2008	6	5609	Tue, 26 August 2008 23:01 By: BlackSwan
ANSI - SQL or Traditional SQL oracle 9.2.0.6 on AIX 5.3 By: sandhyaa on Tue, 12 August 2008	11	6404	Tue, 26 August 2008 10:08 By: Michel Cadot
NOT IN Vs. NOT EXISTS Oracle 9i/ 10g By: Olivia on Wed, 06 August 2008	9	14290	Tue, 26 August 2008 06:12 By: Olivia
Query taking different time in tqo schemas Oracle 10g By: virmahi on Tue, 26 August 2008	1	2098	Tue, 26 August 2008 02:36 By: virmahi
Methods to do tuning Oracle Database 10g Enterprise Edition Release 10.2.0.3.0 - 64bit By: pdhayan@qwest.com on Mon, 25 August 2008	1	1518	Tue, 26 August 2008 00:49 By: Michel Cadot
explain plan and autotrace By: ora1980 on Thu, 21 August 2008	4	3153	Mon, 25 August 2008 01:18 By: Michel Cadot
SQL Tuning Urgent By: ronjubd on Thu, 06 September 2007	7	2659	Sun, 24 August 2008 21:45 By: Kevin Meade
need suggestions to optimize the query oracle 10.2.0.3 solaris 10 By: kumar.joy on Thu, 21 August 2008	3	1842	Sun, 24 August 2008 21:29 By: Kevin Meade
Are system procedures using Rule hint in Oracle 10g? 10g By: Olivia on Thu, 21 August 2008	14	3653	Fri, 22 August 2008 17:30 By: coleing
Performance Tunning issue 9i 9i By: akkumar81 on Thu, 21 August 2008	1	1519	Thu, 21 August 2008 08:04 By: Michel Cadot
Query Taking very long time Oracle 10g By: spmano1983 on Thu, 21 August 2008	4	1410	Thu, 21 August 2008 05:31 By: spmano1983
how to calculate IO for specific SQL Query... Oracle 10g HP Unix By: santoshorcl on Thu, 21 August 2008	3	1550	Thu, 21 August 2008 03:55 By: Michel Cadot
Sql stmt tuning Oracle 8i By: chinmayikkalki on Thu, 21 August 2008	1	1403	Thu, 21 August 2008 02:46 By: Michel Cadot
Performance Issues After Migration By: Asma123 on Wed, 20 August 2008	6	2427	Wed, 20 August 2008 13:27 By: BlackSwan
solaris 10 oracle 10g By: dirish on Wed, 20 August 2008	9	3148	Wed, 20 August 2008 12:50 By: Mahesh Rajendran
Performance tunning Oracle 9i By: manoj12 on Fri, 15 August 2008	7	2549	Wed, 20 August 2008 07:42 By: rleishman
Query Tunning Oracle 10g By: subbu_tce on Tue, 19 August 2008	2	1562	Wed, 20 August 2008 07:33 By: rleishman
dbms job performance issue solarin 5.10, oracle 10.2.0.3 By: kumar.joy on Thu, 31 July 2008	4	2663	Tue, 19 August 2008 15:03 By: kumar.joy
Filter in Oracle By: krshnn592 on Mon, 11 August 2008	5	1708	Mon, 18 August 2008 08:34 By: krshnn592
Gather Schema stats 9.2.0.6.0 IBM AIX By: pokhraj_das on Mon, 18 August 2008	6	2836	Mon, 18 August 2008 05:25 By: pokhraj_das
pstart and pstop By: ArvindBhope on Sun, 17 August 2008	6	7015	Sun, 17 August 2008 08:51 By: Michel Cadot
Query Performance Oracle 10g By: subbu_tce on Sat, 16 August 2008	1	1332	Sat, 16 August 2008 09:28 By: Michel Cadot
HOW TO implement INDEXES ON NEW SCHEMA 10g R1 By: sureshm.ora on Fri, 15 August 2008	10	2621	Sat, 16 August 2008 04:45 By: sureshm.ora
Why RULE hints is used? Oracle 9i By: Olivia on Tue, 12 August 2008	7	2338	Thu, 14 August 2008 22:27 By: rleishman
tracing, connection pools, java programs By: eaganfox on Wed, 13 August 2008	2	1606	Thu, 14 August 2008 22:11 By: eaganfox
Performance issue Oracle 9i By: Olivia on Wed, 13 August 2008	21	3459	Thu, 14 August 2008 09:59 By: Olivia
Update million rows oracle 10g By: ravi214u on Tue, 12 August 2008	6	1916	Wed, 13 August 2008 10:50 By: ravi214u
Calculate leaf_blocks, avg_leaf_blocks_per_key etc. Oracle 9.2.0.8 on Sun OS 5.8 By: john100 on Tue, 12 August 2008	6	4921	Wed, 13 August 2008 09:26 By: john100
Disk I/O started behaving differently when loading data Oracle, 9.2.0.6.0 By: Fadai on Thu, 07 August 2008	13	2562	Wed, 13 August 2008 00:11 By: Fadai
What it suggests? Oracle9i/10g By: Olivia on Tue, 12 August 2008	4	1506	Tue, 12 August 2008 11:42 By: Michel Cadot
Query execution estimation Oracle 10g HP Unix By: santoshorcl on Tue, 12 August 2008	6	1959	Tue, 12 August 2008 07:19 By: Michel Cadot
Source of views Oracle 10g By: hidnana on Tue, 12 August 2008	1	1317	Tue, 12 August 2008 05:30 By: Michel Cadot
oracle instance log increased unix, oracle 10g By: alzuma on Sun, 10 August 2008	4	1593	Mon, 11 August 2008 10:32 By: alanm
gather stats estimated By: ArvindBhope on Mon, 11 August 2008	3	1350	Mon, 11 August 2008 10:13 By: Michel Cadot
shink blob column oracle 10.1.0.3 By: ankush_chawla on Mon, 11 August 2008	0	6386	Mon, 11 August 2008 08:23 By: ankush_chawla
Performance issue Oracle 9.2.0.1.0 By: manoj12 on Wed, 06 August 2008	23	3178	Sun, 10 August 2008 07:24 By: michael_bialik
How to simplify this pivot query By: bztom33 on Thu, 20 September 2007	8	2858	Sat, 09 August 2008 07:05 By: bztom33