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
.