Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Oracle performance problem
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)) impctmissfrom v$latch
regards
Srivenu
Received on Fri Nov 08 2002 - 00:12:05 CST