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
