Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Oracle performance problem

Re: Oracle performance problem

From: srivenu <srivenu_at_hotmail.com>
Date: 7 Nov 2002 22:12:05 -0800
Message-ID: <1a68177.0211072212.784d1249@posting.google.com>


There will not be any performance problems on running 32-bit Oracle on 64-bit SUN OS except that you will be limited to a smaller SGA. You said that you are running 8.1.7. is it 8.1.7.0 ? I had faced a similar problem with a production database on 8.1.7. Found that the reason in due to bug 1967363 (cache buffers latches chains contention for index root blocks) in 8.1.7. Applied patch set 8.1.7.4 and everything works fine now.

Can run the following SQL on your instance (with TIMED_STATISTICS set to true) and send the output.
1)
col event form a40
col total_waits head "Total|Waits"
col total_timeouts head "Total|Time Outs" col time_waited head "Time|Waited|in Secs" form 999999999.9 col average_wait head "Average|Wait|in ms" form 999999999 select event, total_waits,total_timeouts,(time_waited/100) time_waited, average_wait
from v$system_event
order by 3
/

2)
col name form a35
col misses form 9999999
col immediate_gets head "Immediate|Gets" col immediate_misses head "Immediat|Misses" form 9999999 col latch# head "No" form 999
col pctmiss head "Miss%" form 99.99
col impctmiss head "Miss%" form 99.99
select latch#,name,gets,misses,((misses*100)/(gets+1)) pctmiss,

	 immediate_gets,immediate_misses, 
	 ((immediate_misses*100)/(immediate_gets+1)) impctmiss
from v$latch
order by pctmiss+impctmiss
/

regards
Srivenu Received on Fri Nov 08 2002 - 00:12:05 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US