Re: Log_buffer size

From: webbo <hughjanus_at_my-deja.com>
Date: Tue, 06 Jul 1999 12:31:13 GMT
Message-ID: <7lssui$csk$1@nnrp1.deja.com>

Hi,

Check out your Redo Log Space Requests. Idealy these should be Zero, but you will always get some. If you are getting more than 1 request for every 5000 redo entries, then you could do with a bigger buffer. Increase it gradually, untill the Request figure stops growing.

Try this:-

col z for      99999990 head 'Redo|Log|Space|Requests'
col y for      99999990 head 'Entries|per|Request|Ratio'
col x for 9999999990.00 head 'Log|Space|Wait|Time|(secs)'
col w for      99990.00 head 'Time|per|Wait|(secs)'

set head on pages 24 colsep " "

select a.value z,
       b.value/a.value y,
       c.value/100 x,
       (c.value/100)/a.value w
from v$sysstat a,
     v$sysstat b,
     v$sysstat c
where a.name='redo log space requests'

  and b.name='redo entries'
  and c.name='redo log space wait time' ;

Webbo

Sent via Deja.com http://www.deja.com/
Share what you know. Learn what you don't. Received on Tue Jul 06 1999 - 07:31:13 CDT