Hello

Please consider the following statement:

PROMPT
PROMPT Redo Log Buffer should be as close to 0 as possible
PROMPT
COLUMN value FORMAT 9999.9999
COLUMN name FORMAT a50

select
substr(name,1,30) as name,
value
from
v$sysstat
where name ='redo log space requests';
/


The result of the statement when run on my production db (oracle 8.1.7):

"Redo Log Buffer should be as close to 0 as possible"

NAME | VALUE
------------------------| ----------
redo log space requests | 4121.0000


This DB is up for months now, and I don't know if this is a bad number.

The statement came from the oraYAPS (Yet Another Performance Script), from http://www.integer.org. It's a project about building a versatile performce script.

All the results of the statements inside that script looked fine, but I don't trust the result of this particular section.

Can someone tell me how 'bad' this number is and what I should do?

Thanks in advance!!
Erik