Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> RE: SQL for Monitoring; log_buffer entries/growth?

RE: SQL for Monitoring; log_buffer entries/growth?

From: Marquez, Chris <cmarquez_at_collegeboard.org>
Date: Thu, 6 Oct 2005 12:29:32 -0400
Message-ID: <B30C2483766F9342B6AEF108833CC84E05BD5FE0@ecogenemld50.Org.Collegeboard.local>


>>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
Received on Thu Oct 06 2005 - 11:33:45 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US