Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Mailing Lists -> Oracle-L -> Re: Redo Logs Problem
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.
> 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
>
>
>
>
>
>
>
-- 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).Received on Fri Aug 01 2003 - 10:59:36 CDT
![]() |
![]() |