Re: Redo Logs Problem

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.

An alternative is to use v$sess_io and examine the sum of block_changes and consistent_changes. This won't give the redo size, but each change will generate redo, so you can logically link the two conditions. I've done this on several occasions and it has never failed to pinpoint the culprit(s).

Daniel

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Daniel Fink
  INET: daniel.fink_at_sun.com

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).



text/x-vcard attachment: Card for Daniel Fink