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: > 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" <[EMAIL PROTECTED]> > 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: [EMAIL PROTECTED] > > > > 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: [EMAIL PROTECTED] (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: [EMAIL PROTECTED] > > 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: [EMAIL PROTECTED] (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: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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).