oracle官网下载账号ORACLE常用监控语句

发表于2020年7月26日由oracle

ORACLE常用监控语句

 

–查询日志的切换频率

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 minutesfrom v$log_history t1,v$log_history t2where toracle账号1.RECID+1=t2.RECID and /*选择时间段*/t1.FIRST_TIME between trunc(sysdate)/*起始*/ and sysdate/*终止*/order by t1.RECID desc

 

此条目发表在oracle metalink账号分类目录，贴了标签。将固定链接加入收藏夹。