Query to Monitor Redo Log Generation

SELECT lq.leseq “Current log sequence No”, 100*cr.cpodr_bno/lq.lesiz “Percent Full”,
cr.cpodr_bno “Current Block No”, lq.lesiz “Size of Log in Blocks” FROM x$kcccp cr,
x$kccle lq WHERE lq.leseq =CR.cpodr_seq AND bitand(lq.leflg,24) = 8;
  • October 2, 2018 | 16 views
  • Comments