Search notes:

Oracle: X$KCCLE

Log information
select
-- le.addr                        addr,
-- le.indx                        indx,
-- le.inst_id                     inst_id,
-- le.con_id                      con_id,
   le.lenum                       lenum,
   le.leseq                       sequence#,   
   le.lesiz / 1024                log_size_kb,
   le.lebsz                       block_size,   
   le.lehws                       lehws,
   le.lenab                       lenab,
   le.leflg                       leflg,
   le.lethr                       lethr,
   le.lelff                       lelff,
   le.lelfb                       lelfb,
   le.lelos                       lelos,
   le.lelot                       lelot,
   le.lenxs                       lenxs,
   le.lenxt                       lenxt,
   le.lepvs                       lepvs,
   le.learf                       learf,
   le.learb                       learb,
   le.lefnh                       lefnh,
   le.lefnt                       lefnt,
   le.ledup                       ledup
from
   x$kccle le;

lesiz

lesiz is the log block size
This block size is the unit for the init parameters log_checkpoint_interval, _log_io_size and max_dump_file_size.

See also

fixed table

Index