-
Hi ,
Anybody can help me to suggest,how we can find out
# of waits for redo log buffer space.
Thanks
CHEERS
-
Try this query, it shows the number of requests, which should be the same as # of waits:
select name, value from v$sysstat
where name = 'redo log space requests'
Utep
-
Quick note : while tunning, this statistic alone don´t means anything, you need to compare it with the TOTAL redo generated("redo entries"), the "redo blocks written" and the time("redo log space wait time" ).
I have seen ** many ** books and authors saying "if the 'redo log space requests' is > X", then performance will suffer, what isn´t exactly allways right.
Regards,
Chiappa
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
|