查看当前redo logfile文件使用率

set linesize 200 pagesize 1400;

select le.leseq "Current log sequence No",

           100 * cp.cpodr_bno / le.lesiz "Percent Full",

           (cpodr_bno - 1) * 512  "bytes used exclude header",

           le.lesiz * 512 - cpodr_bno * 512 "Left space",

           le.lesiz  *512       "logfile size"

              from x$kcccp cp, x$kccle le

             where LE.leseq = CP.cpodr_seq

             and bitand(le.leflg, 24) = 8;

 

Current log sequence No Percent Full bytes used exclude header Left space logfile size

----------------------- ------------ ------------------------- ---------- ------------

                    539   81.5224609                  42740736    9687552     52428800

 

如上结果显示当前重做日志号为539，使用量百分比是90.7%
当前日志被使用到了 42740736+512 bytes(重做日志文件头)的位置，
还剩余 9687552bytes的空间，该重做日志的总大小为52428800;