-
Result from v$sysstat
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
-
you dont look statstics like that, you must take values between a time interval, i.e delta values
-
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
-
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!
-
not useful scripts at all, if I was you I wouldnt even look at them
-
I'll stay with STATSPACK, UTLBSTAT and UTLESTAT then...
Thanks.