Re: SQL for Monitoring; log_buffer entries/growth?

x$KGopal <http://www.jlcomp.demon.co.uk/faq/redologuse.html>once responded with following info that could be useful to you.

"X$KCCCP will have the redo block number (CPODR_BNO) in the log file. The log block is X$KCCLE.LEBSZ So by joining X$KCCLE and X$KCCCP we can find the current block in the redo log file.

Log file size/X$KCCLE.LEBZ will give you the number of log blocks for that log file. Let us say it is K. X$KCCCP.CPODR_BNO/K*100 will give how much % of log file is full.."

(credit to X$KG.)

check the highlighted link as well.

Raj

On 10/3/05, Marquez, Chris <cmarquez_at_collegeboard.org> wrote:
>
> Yeah I have that one and a few others like it.
>
> Seems now I specifically want to know/find SQL for how much of the
> log_buffer is used/free/growing?
>
> I want to anticipate contention (full log_buffer) rather than seeing the
> resulting (past) waits/stats.
>
> ???
>
> Thanks,
>
> Chris Marquez
>
> Oracle DBA
>
> ------------------------------
> *From:* Hallas, John, Tech Dev [mailto:John.Hallas_at_gb.vodafone.co.uk]
> *Sent:* Monday, October 03, 2005 7:32 AM
> *To:* Marquez, Chris; oracle-l_at_freelists.org
> *Subject:* 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
>
>

--
------------------------------
select standard_disclaimer from company_requirements where category =
'MANDATORY';

--
http://www.freelists.org/webpage/oracle-l