Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Mailing Lists -> Oracle-L -> Re: Redo Logs Problem
Not only that, but the query shown will show redo generation for the
entire life of a session. So if a daemon has been logged in for a
long time but generating redo slowly, it can still look like the top
redo generator. To do this in a purely analytical way, a delta of two
selects from v$sesstat needs to be done. This is pretty easy in perl
on in a spreadsheet even.
-- Jeremiah Wilton http://www.speakeasy.net/~jwilton On Fri, 1 Aug 2003, Tanel Poder wrote:Received on Fri Aug 01 2003 - 11:39:23 CDT
> Hi!
>
> Statistic#'s vary between versions (and possibly platforms), so one should
> use statistic names instead of numbers in scripts.
> Statistic# 99 is "physical reads direct (lob)" in my test environment for
> example.
>
> Tanel.
>
> ----- Original Message -----
> To: "Multiple recipients of list ORACLE-L" <ORACLE-L_at_fatcity.com>
> Sent: Friday, August 01, 2003 6:49 PM
>
>
> > Hi,
> > you may be able to identify the sessions that are generating a lot of redo
> > by running this query. It will list the amount of redo generated by eash
> > session.
> >
> > select s.sid,s.value
> > from v$sesstat s
> > where s.statistic#=99
> > and s.value!=0
> >
> > Cheers,
> > Mike Hately
> >
> >
> >
> > -----Original Message-----
> > Sent: 01 August 2003 10:34
> > To: Multiple recipients of list ORACLE-L
> >
> >
> > Hi Listers,
> >
> > One of my remote Clients is facing a problem with Redo Logs. The Redo Logs
> > and the Archive logs in turn have suddenly started to generate at an
> > alarming Rate. This has suddenly started from the last 1 week without any
> > changes to Database Configuration or any other system settings (as per
> > client).
> >
> > Can anyone please help me and let me know all the reasons that could be
> > responsible for this behavior. Any Help from u will be appreciated.
> >
> > Regards
> >
> > Munish Bajaj
> >
> >
> >
> >
> >
> >
> >
> ****************************************************************************
> ****************
> > E mail Disclaimer
> >
> > You agree that you have read and understood this disclaimer and you agree
> to be bound by its terms.
> >
> > The information contained in this e-mail and any files transmitted with it
> (if any) are confidential and intended for the addressee only. If you have
> received this e-mail in error please notify the originator.
> >
> > This e-mail and any attachments have been scanned for certain viruses
> prior to sending but CE Electric UK Funding Company nor any of its
> associated companies from whom this e-mail originates shall be liable for
> any losses as a result of any viruses being passed on.
> >
> > No warranty of any kind is given in respect of any information contained
> in this e-mail and you should be aware that that it might be incomplete,
> out of date or incorrect. It is therefore essential that you verify all such
> information with us before placing any reliance upon it.
> >
> > CE Electric UK Funding Company
> > Lloyds Court
> > 78 Grey Street
> > Newcastle upon Tyne
> > NE1 6AF
> > Registered in England and Wales: Number 3476201
> >
> >
> ****************************************************************************
> ****************
> >
> > --
> > Please see the official ORACLE-L FAQ: http://www.orafaq.net
> > --
> > Author: Hately, Mike (LogicaCMG)
> > INET: mike.hately_at_nedl.co.uk
> >
> > Fat City Network Services -- 858-538-5051 http://www.fatcity.com
> > San Diego, California -- Mailing list and web hosting services
> > ---------------------------------------------------------------------
> > To REMOVE yourself from this mailing list, send an E-Mail message
> > to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
> > the message BODY, include a line containing: UNSUB ORACLE-L
> > (or the name of mailing list you want to be removed from). You may
> > also send the HELP command for other information (like subscribing).
> >
>
>
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.net
> --
> Author: Tanel Poder
> INET: tanel.poder.003_at_mail.ee
>
> Fat City Network Services -- 858-538-5051 http://www.fatcity.com
> San Diego, California -- Mailing list and web hosting services
> ---------------------------------------------------------------------
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from). You may
> also send the HELP command for other information (like subscribing).
>
-- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Jeremiah Wilton INET: jwilton_at_speakeasy.net Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting services --------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).