Result from v$sysstat

[efrijters]

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

[pando]

you dont look statstics like that, you must take values between a time interval, i.e delta values

[marcio.68]

Not found relation between the URL and the requested information.
How much to the value of it REDO LOG, probably you has a very small value for the amount of transactions effected in this data base.

Statistics of my data bases

DBNAME VALUE
------ ----------
Test 381
pd00 297
pd01 37810
pd02 74

[efrijters]

Link to the script: http://www.integer.org/files/oracle-...nce-tuning.sql

Maybe it is wrong to use these kind of scripts, but I'm just entering the realm of Performance Tuning and I thought it could help me...

Thanks sofar!

[pando]

not useful scripts at all, if I was you I wouldnt even look at them

[efrijters]

I'll stay with STATSPACK, UTLBSTAT and UTLESTAT then...

Thanks.