Re: SQL for Monitoring; log_buffer entries/growth?
- From: rjamya <rjamya@xxxxxxxxx>
- To: cmarquez@xxxxxxxxxxxxxxxx
- Date: Mon, 3 Oct 2005 10:19:33 -0400
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@xxxxxxxxxxxxxxxx> 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@xxxxxxxxxxxxxxxxx]
> *Sent:* Monday, October 03, 2005 7:32 AM
> *To:* Marquez, Chris; oracle-l@xxxxxxxxxxxxx
> *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@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
>
>
--
------------------------------
select standard_disclaimer from company_requirements where category =
'MANDATORY';
Other related posts:
