Re: Redo Activity

From: Jurijs Velikanovs <j.velikanovs_at_gmail.com>
Date: Mon, 22 May 2006 12:09:11 +0100
Message-ID: <d6f0def50605220409r58de1f36ma26980dc322e1763@mail.gmail.com>

Did I miss something?
You don't need to guess any thing.
To my mind the answer is straightforward one:

SELECT s.VALUE
FROM v$sesstat s

      ,v$statname n

WHERE  s.statistic# = n.statistic#
AND    n.NAME LIKE 'redo size'
AND    s.SID = <SID NUMBER>;

For purpose of finding REDO for a SQL*Loader session you can create a LOGOFF trigger and run something like the SQL below within this trigger:

INSERT INTO REGO_GENERATION_LOG ….
SELECT … st.VALUE

FROM   v$sesstat st
      ,v$statname n
      ,v$session ss

WHERE st.statistic# = n.statistic#
AND n.NAME LIKE 'redo size'
AND st.SID = ss.SID
AND ss.audsid = SYS_CONTEXT ('USERENV', 'SESSIONID');

Just my 0.02£,
Yury

On 5/19/06, Ebadi, Abdul <Abdul.Ebadi_at_level3.com> wrote:
> Is there any way to figure out the amount of redo generated per INSERT
> (or any statement)? We are currently loading a table (via conventional
> sqlldr) and are interested to find out how much redo generation will be
> gone if that table is dropped/moved to another DB?
>
> Oracle 9.2.0.4 on Solaris 10.
>
> Thanks,
> Abdul
> --
> http://www.freelists.org/webpage/oracle-l
>
>
>

-- 
Yury
+44 7738 013090 (GMT)
============================================
http://otn.oracle.com/ocm/jvelikanovs.html
--
http://www.freelists.org/webpage/oracle-l

Received on Mon May 22 2006 - 06:09:11 CDT