Oracle redo 日誌切換時間頻率

haoge0205發表於2014-11-10
Oracle Redo
DB: 11.2.0.3.0

檢視Oracle的redo日誌切換頻率

兩條SQL，原理是一樣的，第二個用到了統計函式

時間單位：分鐘

方法一、
select * from v$log　a　where a.THREAD# = 1 ;
set line 200
select b.SEQUENCE#, b.FIRST_TIME,a.SEQUENCE#,a.FIRST_TIME,round(((a.FIRST_TIME-b.FIRST_TIME)*24)*60,2) from v$log_history a, v$log_history b where a.SEQUENCE#=b.SEQUENCE#+1 and b.THREAD#=1 order by a.SEQUENCE# desc;
   

方法二、

set line 200
select sequence#,first_time,nexttime,round(((first_time-nexttime)*24)*60,2) diff from (select sequence#,first_time,lag(first_time) over(order by sequence#) nexttime from v$log_history where thread#=1) order by sequence# desc;

來自 “ ITPUB部落格 ” ，連結：http://blog.itpub.net/28939273/viewspace-1327377/，如需轉載，請註明出處，否則將追究法律責任。

相關文章