查看oracle中redo的切换频率

附脚本：

select

b.sequence#,

b.first_time,

a.sequence#,

a.first_time,

round(((a.first_time-b.first_time)*24)*60,2)

from v$log_history a, v$log_history b

where

a.sequence#=b.sequence#+1

and b.thread#=1

order by a.sequence# desc;