Raj, Thanks...I will have a look. Chris Marquez Oracle DBA -----Original Message----- From: rjamya [mailto:rjamya@xxxxxxxxx] Sent: Mon 10/3/2005 10:19 AM To: Marquez, Chris Cc: Hallas, John, Tech Dev; oracle-l@xxxxxxxxxxxxx Subject: 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@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';