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
response time By: ArvindBhope on Wed, 27 August 2008	3	1516	Thu, 28 August 2008 01:24 By: Michel Cadot
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	3844	Wed, 27 August 2008 11:30 By: orasaket
Does it mean Explain plan? Oracle9i By: Olivia on Tue, 26 August 2008	7	4546	Wed, 27 August 2008 04:33 By: Michel Cadot
Row Chaining problem 10.2.0.3 By: sudhir1582 on Wed, 27 August 2008	1	1635	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	5754	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	6619	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	14472	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	2207	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	1670	Tue, 26 August 2008 00:49 By: Michel Cadot
explain plan and autotrace By: ora1980 on Thu, 21 August 2008	4	3277	Mon, 25 August 2008 01:18 By: Michel Cadot
SQL Tuning Urgent By: ronjubd on Thu, 06 September 2007	7	2786	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	1978	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	3828	Fri, 22 August 2008 17:30 By: coleing
Performance Tunning issue 9i 9i By: akkumar81 on Thu, 21 August 2008	1	1629	Thu, 21 August 2008 08:04 By: Michel Cadot
Query Taking very long time Oracle 10g By: spmano1983 on Thu, 21 August 2008	4	1564	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	1694	Thu, 21 August 2008 03:55 By: Michel Cadot
Sql stmt tuning Oracle 8i By: chinmayikkalki on Thu, 21 August 2008	1	1527	Thu, 21 August 2008 02:46 By: Michel Cadot
Performance Issues After Migration By: Asma123 on Wed, 20 August 2008	6	2586	Wed, 20 August 2008 13:27 By: BlackSwan
solaris 10 oracle 10g By: dirish on Wed, 20 August 2008	9	3316	Wed, 20 August 2008 12:50 By: Mahesh Rajendran
Performance tunning Oracle 9i By: manoj12 on Fri, 15 August 2008	7	2693	Wed, 20 August 2008 07:42 By: rleishman
Query Tunning Oracle 10g By: subbu_tce on Tue, 19 August 2008	2	1692	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	2812	Tue, 19 August 2008 15:03 By: kumar.joy
Filter in Oracle By: krshnn592 on Mon, 11 August 2008	5	1862	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	3041	Mon, 18 August 2008 05:25 By: pokhraj_das
pstart and pstop By: ArvindBhope on Sun, 17 August 2008	6	7234	Sun, 17 August 2008 08:51 By: Michel Cadot
Query Performance Oracle 10g By: subbu_tce on Sat, 16 August 2008	1	1468	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	2807	Sat, 16 August 2008 04:45 By: sureshm.ora
Why RULE hints is used? Oracle 9i By: Olivia on Tue, 12 August 2008	7	2533	Thu, 14 August 2008 22:27 By: rleishman
tracing, connection pools, java programs By: eaganfox on Wed, 13 August 2008	2	1733	Thu, 14 August 2008 22:11 By: eaganfox
Performance issue Oracle 9i By: Olivia on Wed, 13 August 2008	21	3770	Thu, 14 August 2008 09:59 By: Olivia
Update million rows oracle 10g By: ravi214u on Tue, 12 August 2008	6	2081	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	5105	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	2733	Wed, 13 August 2008 00:11 By: Fadai
What it suggests? Oracle9i/10g By: Olivia on Tue, 12 August 2008	4	1655	Tue, 12 August 2008 11:42 By: Michel Cadot
Query execution estimation Oracle 10g HP Unix By: santoshorcl on Tue, 12 August 2008	6	2139	Tue, 12 August 2008 07:19 By: Michel Cadot
Source of views Oracle 10g By: hidnana on Tue, 12 August 2008	1	1467	Tue, 12 August 2008 05:30 By: Michel Cadot
oracle instance log increased unix, oracle 10g By: alzuma on Sun, 10 August 2008	4	1738	Mon, 11 August 2008 10:32 By: alanm
gather stats estimated By: ArvindBhope on Mon, 11 August 2008	3	1508	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	6521	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	3476	Sun, 10 August 2008 07:24 By: michael_bialik