RE: SQL for Monitoring; log_buffer entries/growth?

>>Tim Gorman had a very nice script

I can not seem to find it?

>>it would track log growth for several days.

log_buffer entries/growth?

Thanks,

Chris Marquez
Oracld DBA

-----Original Message-----
From: Barbara Baker [mailto:barb.baker_at_gmail.com] Sent: Tue 10/4/2005 9:58 AM
To: Marquez, Chris
Cc: oracle-l_at_freelists.org
Subject: Re: SQL for Monitoring; log_buffer entries/growth?  

Chris:
Tim Gorman had a very nice script at his site (www.evdbt.com<http://www.evdbt.com>)
I believe it would track log growth for several days. It's probably still there.
You might have a look.
Barb

On 9/30/05, Marquez, Chris <cmarquez_at_collegeboard.org> wrote:
>
> 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