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	2456	Thu, 28 August 2008 12:54 By: BlackSwan
AWR Service Stats By: lunaut on Thu, 28 August 2008	1	3041	Thu, 28 August 2008 12:54 By: Michel Cadot
10g Database Performance By: Asma123 on Thu, 28 August 2008	1	2034	Thu, 28 August 2008 10:47 By: Michel Cadot
response time By: ArvindBhope on Wed, 27 August 2008	3	2375	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	4303	Wed, 27 August 2008 11:30 By: orasaket
Does it mean Explain plan? Oracle9i By: Olivia on Tue, 26 August 2008	7	5156	Wed, 27 August 2008 04:33 By: Michel Cadot
Row Chaining problem 10.2.0.3 By: sudhir1582 on Wed, 27 August 2008	1	2307	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	7359	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	7648	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	15385	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	2598	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	2359	Tue, 26 August 2008 00:49 By: Michel Cadot
explain plan and autotrace By: ora1980 on Thu, 21 August 2008	4	4457	Mon, 25 August 2008 01:18 By: Michel Cadot
SQL Tuning Urgent By: ronjubd on Thu, 06 September 2007	7	3889	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	2490	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	4939	Fri, 22 August 2008 17:30 By: coleing
Performance Tunning issue 9i 9i By: akkumar81 on Thu, 21 August 2008	1	2237	Thu, 21 August 2008 08:04 By: Michel Cadot
Query Taking very long time Oracle 10g By: spmano1983 on Thu, 21 August 2008	4	2458	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	2333	Thu, 21 August 2008 03:55 By: Michel Cadot
Sql stmt tuning Oracle 8i By: chinmayikkalki on Thu, 21 August 2008	1	1834	Thu, 21 August 2008 02:46 By: Michel Cadot
Performance Issues After Migration By: Asma123 on Wed, 20 August 2008	6	3693	Wed, 20 August 2008 13:27 By: BlackSwan
solaris 10 oracle 10g By: dirish on Wed, 20 August 2008	9	5675	Wed, 20 August 2008 12:50 By: Mahesh Rajendran
Performance tunning Oracle 9i By: manoj12 on Fri, 15 August 2008	7	3352	Wed, 20 August 2008 07:42 By: rleishman
Query Tunning Oracle 10g By: subbu_tce on Tue, 19 August 2008	2	2451	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	3387	Tue, 19 August 2008 15:03 By: kumar.joy
Filter in Oracle By: krshnn592 on Mon, 11 August 2008	5	2928	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	3914	Mon, 18 August 2008 05:25 By: pokhraj_das
pstart and pstop By: ArvindBhope on Sun, 17 August 2008	6	8696	Sun, 17 August 2008 08:51 By: Michel Cadot
Query Performance Oracle 10g By: subbu_tce on Sat, 16 August 2008	1	2028	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	3731	Sat, 16 August 2008 04:45 By: sureshm.ora
Why RULE hints is used? Oracle 9i By: Olivia on Tue, 12 August 2008	7	4381	Thu, 14 August 2008 22:27 By: rleishman
tracing, connection pools, java programs By: eaganfox on Wed, 13 August 2008	2	2484	Thu, 14 August 2008 22:11 By: eaganfox
Performance issue Oracle 9i By: Olivia on Wed, 13 August 2008	21	5404	Thu, 14 August 2008 09:59 By: Olivia
Update million rows oracle 10g By: ravi214u on Tue, 12 August 2008	6	2754	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	5939	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	3760	Wed, 13 August 2008 00:11 By: Fadai
What it suggests? Oracle9i/10g By: Olivia on Tue, 12 August 2008	4	2181	Tue, 12 August 2008 11:42 By: Michel Cadot
Query execution estimation Oracle 10g HP Unix By: santoshorcl on Tue, 12 August 2008	6	3292	Tue, 12 August 2008 07:19 By: Michel Cadot
Source of views Oracle 10g By: hidnana on Tue, 12 August 2008	1	2099	Tue, 12 August 2008 05:30 By: Michel Cadot
oracle instance log increased unix, oracle 10g By: alzuma on Sun, 10 August 2008	4	2660	Mon, 11 August 2008 10:32 By: alanm