[管理脚本] 日志切换频率

select
    b.SEQUENCE#,
    b.FIRST_TIME,
    a.SEQUENCE#,
    a.FIRST_TIME,
    round(((a.FIRST_TIME-b.FIRST_TIME)*24)*60,2) minutes
from
    v$log_history a, v$log_history b
where
    a.SEQUENCE# = b.SEQUENCE#+1 and
    b.THREAD#=1
order by
    a.SEQUENCE# desc
/