Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Mailing Lists -> Oracle-L -> 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
-- http://www.freelists.org/webpage/oracle-lReceived on Fri Sep 30 2005 - 10:43:02 CDT
![]() |
![]() |