REDO

How to get block size of redologs in oracle

We all know about the database block size. Remember db_block_size. But where the redo block size is defined.??? Answer is -> Redo block size is platform specific . It will the take the default valu...

Find utilization of redo logs

Below is the script to find the utilizations of redo logs 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...