实用的数据库检查程序(2)[1]

[入库:2005年8月18日] [更新:2007年3月24日]

本文简介:选择自 black_snail 的 blog

ttitle off

 

prompt ++++++++++++++++++++++++++++++++++ item ++++++++++++++++++++++++++++++++++

prompt + 3.0 log switch in the last day                                         +

prompt ++++++++++++++++++++++++++++++++++ item ++++++++++++++++++++++++++++++++++

prompt

 

ttitle left "*** database: "xdbname", how offen the log switch(as of : "xdate" ) ***" skip 1

 

column archive_name format a40

column "time" format a25

 

select to_char(to_date(time,'mm/dd/rr hh24:mi:ss'),'dd-mon-rrrr hh24:mi:ss') "time",

     archive_name

from v$log_history

where to_date(time,'mm/dd/rr hh24:mi:ss') > sysdate - 1

order by to_date(time,'mm/dd/rr hh24:mi:ss') desc ;

 

prompt

prompt <<<<<<<<<<<<<<<<<<< note: >>>>>>>>>>>>>>>>>>>>>>

prompt 3.0 invesigation

prompt standard:

prompt during periods of high activity , log switches are occurring every 20 minutes

本文关键:ORACLE DBA SCRIPT
  相关方案
Google
 

本站最佳浏览方式为 分辨率 1024x768 IE 6.0(或更高版本的 IE浏览器)

go top