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
memory in statspack 9i windows By: blakshmi on Thu, 28 August 2008	2	2400	Thu, 28 August 2008 12:54 By: BlackSwan
AWR Service Stats By: lunaut on Thu, 28 August 2008	1	3010	Thu, 28 August 2008 12:54 By: Michel Cadot
10g Database Performance By: Asma123 on Thu, 28 August 2008	1	1986	Thu, 28 August 2008 10:47 By: Michel Cadot
response time By: ArvindBhope on Wed, 27 August 2008	3	2312	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	4244	Wed, 27 August 2008 11:30 By: orasaket
Does it mean Explain plan? Oracle9i By: Olivia on Tue, 26 August 2008	7	5080	Wed, 27 August 2008 04:33 By: Michel Cadot
Row Chaining problem 10.2.0.3 By: sudhir1582 on Wed, 27 August 2008	1	2254	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	7267	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	7524	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	15254	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	2555	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	2320	Tue, 26 August 2008 00:49 By: Michel Cadot
explain plan and autotrace By: ora1980 on Thu, 21 August 2008	4	4386	Mon, 25 August 2008 01:18 By: Michel Cadot
SQL Tuning Urgent By: ronjubd on Thu, 06 September 2007	7	3781	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	2433	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	4780	Fri, 22 August 2008 17:30 By: coleing
Performance Tunning issue 9i 9i By: akkumar81 on Thu, 21 August 2008	1	2186	Thu, 21 August 2008 08:04 By: Michel Cadot
Query Taking very long time Oracle 10g By: spmano1983 on Thu, 21 August 2008	4	2410	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	2300	Thu, 21 August 2008 03:55 By: Michel Cadot
Sql stmt tuning Oracle 8i By: chinmayikkalki on Thu, 21 August 2008	1	1793	Thu, 21 August 2008 02:46 By: Michel Cadot
Performance Issues After Migration By: Asma123 on Wed, 20 August 2008	6	3608	Wed, 20 August 2008 13:27 By: BlackSwan
solaris 10 oracle 10g By: dirish on Wed, 20 August 2008	9	5560	Wed, 20 August 2008 12:50 By: Mahesh Rajendran
Performance tunning Oracle 9i By: manoj12 on Fri, 15 August 2008	7	3252	Wed, 20 August 2008 07:42 By: rleishman
Query Tunning Oracle 10g By: subbu_tce on Tue, 19 August 2008	2	2385	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	3323	Tue, 19 August 2008 15:03 By: kumar.joy
Filter in Oracle By: krshnn592 on Mon, 11 August 2008	5	2840	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	3811	Mon, 18 August 2008 05:25 By: pokhraj_das
pstart and pstop By: ArvindBhope on Sun, 17 August 2008	6	8590	Sun, 17 August 2008 08:51 By: Michel Cadot
Query Performance Oracle 10g By: subbu_tce on Sat, 16 August 2008	1	1975	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	3613	Sat, 16 August 2008 04:45 By: sureshm.ora
Why RULE hints is used? Oracle 9i By: Olivia on Tue, 12 August 2008	7	4310	Thu, 14 August 2008 22:27 By: rleishman
tracing, connection pools, java programs By: eaganfox on Wed, 13 August 2008	2	2449	Thu, 14 August 2008 22:11 By: eaganfox
Performance issue Oracle 9i By: Olivia on Wed, 13 August 2008	21	5231	Thu, 14 August 2008 09:59 By: Olivia
Update million rows oracle 10g By: ravi214u on Tue, 12 August 2008	6	2695	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	5859	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	3602	Wed, 13 August 2008 00:11 By: Fadai
What it suggests? Oracle9i/10g By: Olivia on Tue, 12 August 2008	4	2120	Tue, 12 August 2008 11:42 By: Michel Cadot
Query execution estimation Oracle 10g HP Unix By: santoshorcl on Tue, 12 August 2008	6	3204	Tue, 12 August 2008 07:19 By: Michel Cadot
Source of views Oracle 10g By: hidnana on Tue, 12 August 2008	1	2046	Tue, 12 August 2008 05:30 By: Michel Cadot
oracle instance log increased unix, oracle 10g By: alzuma on Sun, 10 August 2008	4	2588	Mon, 11 August 2008 10:32 By: alanm