Optimal logfile size

set lines 200
set pages 60

column buckets       format 9999999
column name          format a12

select n.name, t.value
from v$mystat   t join v$statname n
on t.statistic# = n.statistic#
where n.name = ‘redo size’;

select optimal_logfile_size
from v$instance_recovery;

  • January 12, 2018 | 14 views
  • Comments