To: "Barbara Baker" <barb.baker@xxxxxxxxx>, <oracle-l@xxxxxxxxxxxxx>
Date: Thu, 6 Oct 2005 12:29:32 -0400
>>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@xxxxxxxxx]
Sent: Tue 10/4/2005 9:58 AM
To: Marquez, Chris
Cc: oracle-l@xxxxxxxxxxxxx
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@xxxxxxxxxxxxxxxx> 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
>
>
>
