redo log 切换

测试redo log 切换时间，使用如下语句：

 

select b.recid,
to_char(b.first_time,'dd-mon-yy hh:mi:ss') start_time, a.recid,
to_char(a.first_time,'dd-mon-yy hh:mi:ss') end_time,
round(((a.first_time-b.first_time)*25)*60,2) minutes
from v$log_history a, v$log_history b
where a.recid = b.recid+1
order by a.first_time asc

 

来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/24862808/viewspace-718364/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/24862808/viewspace-718364/