Result from v$sysstat
Please consider the following statement:
PROMPT Redo Log Buffer should be as close to 0 as possible
COLUMN value FORMAT 9999.9999
COLUMN name FORMAT a50
substr(name,1,30) as name,
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!!
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
Márcio de Souza Almeida
DBA Oracle / SQLServer / PostgreSQL
Rua Cupa, 139 Apto 85 A
Penha - São Paulo - SP
03640-000 - Brasil
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...
not useful scripts at all, if I was you I wouldnt even look at them
I'll stay with STATSPACK, UTLBSTAT and UTLESTAT then...
Click Here to Expand Forum to Full Width