|
[oracle-l]
||
[Date Prev]
[10-2005 Date Index]
[Date Next]
||
[Thread Prev]
[10-2005 Thread Index]
[Thread Next]
RE: SQL for Monitoring; log_buffer entries/growth?
- From: "Hallas, John, Tech Dev" <John.Hallas@xxxxxxxxxxxxxxxxx>
- To: <cmarquez@xxxxxxxxxxxxxxxx>, <oracle-l@xxxxxxxxxxxxx>
- Date: Mon, 3 Oct 2005 12:32:26 +0100
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@xxxxxxxxxxxxx
[mailto:oracle-l-bounce@xxxxxxxxxxxxx] On Behalf Of Marquez, Chris
Sent: 30 September 2005 16:40
To: oracle-l@xxxxxxxxxxxxx
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
|
|
