SQL for Monitoring; log_buffer entries/growth?

Got any SQL for me?

Want to monitor how the log buffer entries are reacting / growing.
What is best to see how the buffer is performing or log buffer activity?

SELECT name, value  FROM V$SYSSTAT WHERE NAME like 'redo%' ???
Specifically "redo buffer allocation retries" ???

PS I know I have activity as we are archiving like crazy during heavy load.

Thanks in advance.

Chris Marquez
Oracle DBA


Other related posts: