ITPub博客

首页 > Linux操作系统 > Linux操作系统 > Query the duration of log switch

Query the duration of log switch

原创 Linux操作系统 作者:oracle_ace 时间:2009-05-07 14:26:02 0 删除 编辑
Here is a query that will show you the time between log switches. It can be handy in determining if you have a problem:

select b.recid,
to_char(b.first_time,'dd-mon-yy hh:mi:ss') start_time, a.recid,
to_char(a.first_time,'dd-mon-yy hh:mi:ss') end_time,
round(((a.first_time-b.first_time)*25)*60,2) minutes
from v$log_history a, v$log_history b
where a.recid = b.recid+1
order by a.first_time asc
/

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

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

注册时间:2007-12-10

  • 博文量
    284
  • 访问量
    800341