-
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
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|