查看联机重做日志文件的切换时间间隔

来源:互联网 发布:特殊字体软件 编辑:程序博客网 时间:2024/04/27 14:34
SELECT * FROM (SELECT B .sequence# , B.FIRST_TIME,A. FIRST_TIME LAST_TIME,ROUND((A.FIRST_TIME -B .FIRST_TIME)*24*60,2) MINATES FROM V$LOG_HISTORY A,V$LOG_HISTORY B
         WHERE A. RECID =B . RECID+ 1 ORDER BY A. FIRST_TIME DESC)WHERE ROWNUM <120
0 0
原创粉丝点击