DB: 11.2.0.3.0
查看Oracle的redo日志切换频率
两条SQL，原理是一样的，第二个用到了统计函数
时间单位：分钟
方法一、
select * from v$log a where a.THREAD# = 1 ;
方法二、
set line 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;
查看Oracle的redo日志切换频率
两条SQL，原理是一样的，第二个用到了统计函数
时间单位：分钟
方法一、
select * from v$log a where a.THREAD# = 1 ;
set line 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;
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 line 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/28939273/viewspace-1327377/ ，如需转载，请注明出处，否则将追究法律责任。
下一篇：
MySQL 简洁连接数据库方式
请登录后发表评论
登录
全部评论
