Oracle查看日志切换时间

两个sql，原理是一样的，第二个用到了统计函数。 
时间单位：分钟 

set linesize 200
set pagesize 200
select * from v$log 
where a.THREAD# = 1 

set linesize 200
set pagesize 200
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; 

set linesize 200
set pagesize 200
select sequence#,first_time,nexttime,round(((first_time-nexttime)*24)*60,2) diff 
from ( 
select sequence#,first_time, lag(first_time) over(order by sequence#) nexttime 
from v$log_history 
where thread#=1 
) order by sequence# desc; 

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

转载于:http://blog.itpub.net/31448824/viewspace-2136604/