VIEW: DBSNMP.MGMT_BSLN_INTERVALS

Source

View Text - Preformatted

select bb.bsln_guid
      ,case ab.baseline_type when 'MOVING_WINDOW' then NULL
                             else ab.start_snap_time end
      ,case ab.baseline_type when 'MOVING_WINDOW' then NULL
                             else ab.end_snap_time end
      ,case ab.baseline_type when 'MOVING_WINDOW' then ab.moving_window_size
                             else NULL end
  from bsln_baselines bb, dba_hist_baseline ab, gv$instance i
 where ab.dbid = bb.dbid
   and ab.baseline_id = bb.baseline_id
   and i.instance_name = bb.instance_name
   and ab.baseline_type in ('MOVING_WINDOW', 'STATIC', 'GENERATED')

View Text - HTML Formatted

SELECT BB.BSLN_GUID
, CASE AB.BASELINE_TYPE WHEN 'MOVING_WINDOW' THEN NULL ELSE AB.START_SNAP_TIME END
, CASE AB.BASELINE_TYPE WHEN 'MOVING_WINDOW' THEN NULL ELSE AB.END_SNAP_TIME END
, CASE AB.BASELINE_TYPE WHEN 'MOVING_WINDOW' THEN AB.MOVING_WINDOW_SIZE ELSE NULL END
FROM BSLN_BASELINES BB
, DBA_HIST_BASELINE AB
, GV$INSTANCE I
WHERE AB.DBID = BB.DBID
AND AB.BASELINE_ID = BB.BASELINE_ID
AND I.INSTANCE_NAME = BB.INSTANCE_NAME
AND AB.BASELINE_TYPE IN ('MOVING_WINDOW'
, 'STATIC'
, 'GENERATED')