Re: Redol logs

If you are using 8.1.x or beyond try the following steps

find out the current log by querying v$log / v$logfile use the dbms_logmnr package on that log
and run the following query:

SELECT scn,rbablk*512,

       to_char(timestamp,'YYYY/MM/DD HH24:MI:SS')   FROM v$logmnr_contents
/

This will give you the current number of bytes written to in the current log

"sudhakar kalra" <ksudhakar_in_at_yahoo.com> wrote in message

news:d38c9c2b.0110240141.545baf03_at_posting.google.com...

> Hi all,
>
> Have one question ..it might be silly !!!
>
> How can we know the exact size of filled redolog ??? To exemplify i
> have redologs of size 500m each. The first group is being written .
> How do i know how much of it is really filled? One way i know of is
> switch and go and check the archivelog size but i want some other way
> ...
>
>
> Any ideas...
>
> Thanks,
> Sudhakar

-- 
Posted from d225s240.hotbank.com [63.83.225.240] 
via Mailgate.ORG Server - http://www.Mailgate.ORG