ITPub博客

首页 > 数据库 > Oracle > redo_log_switch_date

redo_log_switch_date

Oracle 作者:531968912 时间:2015-12-24 09:14:18 0 删除 编辑
<br /> <br /> select sequence#,<br /> &nbsp; &nbsp; &nbsp; &nbsp;to_char(first_time, 'yyyy-mm-dd hh24:mi') || ' ' ||<br /> &nbsp; &nbsp; &nbsp; &nbsp;to_char(nexttime, 'hh24:mi'),<br /> &nbsp; &nbsp; &nbsp; &nbsp;round(((first_time - nexttime) * 24) * 60, 2) diff<br /> &nbsp; from (select sequence#,<br /> &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;first_time,<br /> &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;lag(first_time) over(order by sequence#) nexttime<br /> &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; from v$log_history<br /> &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;where thread# = 1<br /> &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;and trunc(first_time) &gt;= sysdate - 8)<br /> where round(((first_time - nexttime) * 24) * 60, 2) &gt; 0<br /> order by sequence# desc;<br />

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

请登录后发表评论 登录
全部评论

注册时间:2014-09-24

  • 博文量
    574
  • 访问量
    835170