Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> SQL for Monitoring; log_buffer entries/growth?

SQL for Monitoring; log_buffer entries/growth?

From: Marquez, Chris <cmarquez_at_collegeboard.org>
Date: Fri, 30 Sep 2005 11:40:04 -0400
Message-ID: <B30C2483766F9342B6AEF108833CC84E05BD5FCA@ecogenemld50.Org.Collegeboard.local>


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
Received on Fri Sep 30 2005 - 10:43:02 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US