今天合作伙伴需要一个redo切换的情况,因为是RAC环境,需要将网上的语句修改一下,试试。
select b.sequence#,
to_char(b.first_time,'dd-mon-yy hh:mi:ss') start_time,
a.sequence#,
to_char(a.first_time,'dd-mon-yy hh:mi:ss') end_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 a.thread=1 and b.thread=1
order by a.sequence# desc;
select b.sequence#,
to_char(b.first_time,'dd-mon-yy hh:mi:ss') start_time,
a.sequence#,
to_char(a.first_time,'dd-mon-yy hh:mi:ss') end_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 a.thread=1 and b.thread=1
order by a.sequence# desc;
来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/11946422/viewspace-672532/,如需转载,请注明出处,否则将追究法律责任。
转载于:http://blog.itpub.net/11946422/viewspace-672532/