熱點推薦:
您现在的位置: 電腦知識網 >> 編程 >> Oracle >> 正文

查看Oracle的redo日志切換頻率

2013-11-13 22:13:00  來源: Oracle 

  兩個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
    推薦文章
    Copyright © 2005-2013 電腦知識網 Computer Knowledge   All rights reserved.