Re: REDO logs

Try:

select a.group#, a.member
from v$logfile a, v$log b
where a.group#=b.group# and

           b.status='CURRENT';

M.Landa

Stan Novinsky wrote:

> Is there a commnad that can tell you what REDO log is currently being
> written into. I
> checked the SYS.V$LOGFILE. This gives info for the ACTIVE, STALE,
> etc.
>
> Thanks
Received on Tue Jan 20 1998 - 00:00:00 CST