ORACLE常用监控语句(未完待续)

最新推荐文章于 2024-09-23 14:16:45 发布

weixin_30686845

最新推荐文章于 2024-09-23 14:16:45 发布

阅读量95

点赞数

文章标签：数据库

原文链接：http://www.cnblogs.com/james1207/p/3255887.html

版权

--查询日志的切换频率
select t1.RECID as srecid
       ,t2.RECID as erecid
       ,t1.FIRST_TIME as stime
       ,t2.FIRST_TIME as etime
       ,round((t2.FIRST_TIME-t1.FIRST_TIME)*1440,2) as minutes
from v$log_history t1,v$log_history t2
where t1.RECID+1=t2.RECID and /*选择时间段*/t1.FIRST_TIME between trunc(sysdate)/*起始*/ and sysdate/*终止*/
order by t1.RECID desc

转载于:https://www.cnblogs.com/james1207/p/3255887.html