38 lines
1.1 KiB
SQL
38 lines
1.1 KiB
SQL
--------------------------------------------------------------------------------
|
|
--
|
|
-- Author: Tanel Poder
|
|
-- Copyright: (c) http://www.tanelpoder.com
|
|
--
|
|
-- Notes: This software is provided AS IS and doesn't guarantee anything
|
|
-- Proofread before you execute it!
|
|
--
|
|
--------------------------------------------------------------------------------
|
|
|
|
--set lines 156
|
|
|
|
column sawr_list_takenby heading "Taken By" format a20
|
|
column sawr_list_snapid heading "Snap ID" format 9999999
|
|
column sawr_list_snaptime heading "Snapshot Time" format a20
|
|
column sawr_session_count heading "Snapped|Sessions" format 9999999
|
|
column sawr_snap_mode heading "Snapshot|Mode" format a40
|
|
|
|
select
|
|
snap.snapid sawr_list_snapid,
|
|
to_char(snap.snaptime, 'YYYY-MM-DD HH24:MI:SS') sawr_list_snaptime,
|
|
snap.takenby sawr_list_takenby,
|
|
snap.snap_mode sawr_snap_mode,
|
|
count(*) sawr_session_count
|
|
from
|
|
sawr$snapshots snap,
|
|
sawr$sessions sess
|
|
where
|
|
snap.snapid = sess.snapid
|
|
group by
|
|
snap.snapid,
|
|
to_char(snap.snaptime, 'YYYY-MM-DD HH24:MI:SS'),
|
|
snap.snap_mode,
|
|
snap.takenby
|
|
order by
|
|
to_char(snap.snaptime, 'YYYY-MM-DD HH24:MI:SS')
|
|
/
|