查看Oracle的redo日志切換頻率

　　兩個sql原理是一樣的第二個用到了統計函數

　　時間單位分鐘

　　select * from v$log

　　where aTHREAD# =

　　select bSEQUENCE# bFIRST_TIME

　　aSEQUENCE# aFIRST_TIME

　　round(((aFIRST_TIMEbFIRST_TIME)*)*)

　　from v$log_history a v$log_history b

　　where aSEQUENCE# = bSEQUENCE#+

　　and bTHREAD#=

　　order by aSEQUENCE# desc

　　select sequence#first_timenexttimeround(((first_timenexttime)*)*) diff

　　from (

　　select sequence#first_time lag(first_time) over(order by sequence#) nexttime

　　from v$log_history

　　where thread#=

　　) order by sequence# desc

From:http://tw.wingwit.com/Article/program/Oracle/201311/18503.html