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
begin:vcard
n:Fink;Daniel
tel;cell:303.808.3282
tel;work:303.272.3225
x-mozilla-html:TRUE
adr:;;;;;;
version:2.1
email;internet:[EMAIL PROTECTED]
title:DB Services Lead
x-mozilla-cpt:;-4832
fn:Daniel Fink
end:vcard
