How to check the size of current redo log?
Posted: Thu Jan 19, 2012 9:40 pm
Below is the query to determine the size of current redo log file:
Sample Output:
Code: Select all
SELECT le.leseq "Current log sequence No",
100*cp.cpodr_bno/le.lesiz "Percent Full",
cp.cpodr_bno "Current Block No",
le.lesiz "Size of Log in Blocks"
FROM x$kcccp cp, x$kccle le
WHERE le.leseq =CP.cpodr_seq
AND bitand(le.leflg,24) = 8
/Code: Select all
Current log sequence No Percent Full Current Block No Size of Log in Blocks
----------------------- ------------ ---------------- ---------------------
88 60.8300781 62290 102400