两个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;
时间单位：分钟
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博客 ” ，链接：https://blog.itpub.net/31448824/viewspace-2136604/ ，如需转载，请注明出处，否则将追究法律责任。
上一篇：
不commit能否将脏数据写入数据文件
下一篇：
查询session的闲置时间
请登录后发表评论
登录
全部评论
