V$LOG

Information on each log group.

Columns
   ___________________________
 
   GROUP#
   THREAD#
   SEQUENCE#
   BYTES
   MEMBERS
   ARCHIVED
   STATUS     (active,inactive,current,unused)
   FIRST_CHANGE#
   FIRST_TIME

Related:

V$LOGFILE 
V$LOGHIST 
V$LOG_HISTORY


© Copyright SS64.com 1999-2013
Some rights reserved