Wednesday, November 13, 2013

script to list snapshot in oracle AWR?

col "Date/Time" format a30
select snap_id
,       snap_level
, to_char(snap_time,'HH24:MI:SS DD-MM-YYYY') "Date/Time"
from stats$snapshot
, v$database
order by snap_id
/

No comments:

Post a Comment