Redo Log Status

col sequence heading 'Sequence #' format 999999999
col pct_full heading '% Full'     format 999.99
select le.leseq   sequence,
       round(100*cp.cpodr_bno/le.lesiz,2) pct_full
  from x$kcccp cp, x$kccle le
 where le.leseq =CP.cpodr_seq
   and bitand(le.leflg,24) = 8
/

  SEQUENCE   PCT_FULL
---------- ----------
      5267      16.27
      1079        .59