Give or take a few bytes, yes, presuming the next transaction for the
redo logs will fit in the current log. If a transaction record cannot
fit into the available space in a given redo log the log is switched
and the transaction record is written to a new log. But for the most
part one can safely presume that redo logs are filled to capacity, so
a 500 Meg redo log will contain 500 Meg of transaction records.
"Sybrand Bakker" <postbus_at_sybrandb.demon.nl> wrote in message news:<ttdaaj11b1dpab_at_corp.supernews.com>...
> "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
>
> AFAIK unless you switch them manually they are always filled up to the max.
>
> Hth,
>
> Sybrand Bakker
> Senior Oracle DBA
Received on Wed Oct 24 2001 - 14:51:11 CDT
