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
Received on Tue Oct 04 2005 - 09:01:39 CDT
