RE: SQL for Monitoring; log_buffer entries/growth?

Howabout , the following but I am sure you have looked at that already  

John  

PROMPT ================================================================

PROMPT Redo Log Space Requests

PROMPT Should be near 0

PROMPT If greater, increase 'log_buffer' parameter

select name, value

from v$sysstat

where name = 'redo log space requests'

/      

From: oracle-l-bounce_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Marquez, Chris Sent: 30 September 2005 16:40
To: oracle-l_at_freelists.org
Subject: 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-l