VIEW: SYS.DBA_WORKLOAD_FILTERS

Source

View Text - Preformatted

select
 f.filter_type,
 decode(f.wrr_id, 0, NULL, f.wrr_id),
 (case when c.status = 'IN PROGRESS'
       then 'IN USE'
       when f.wrr_id = 0
       then 'NEW'
       else 'USED'
  end) as status,
 NULL, f.name, f.attribute, f.value
from
 wrr$_filters  f,
 wrr$_captures c
where f.wrr_id = c.id(+)
  and f.filter_type = 'CAPTURE'
UNION ALL
select
 f.filter_type,
 decode(f.wrr_id, 0, NULL, f.wrr_id),
 (case when r.status = 'IN PROGRESS'
         or r.status = 'INITIALIZED'
         or r.status = 'PREPARE'
       then 'IN USE'
       when f.wrr_id = 0
       then 'NEW'
       else 'USED'
  end) as status,
 r.filter_set_name, f.name, f.attribute, f.value
from
 wrr$_filters  f,
 wrr$_replays r
where f.filter_type = 'REPLAY'
  and f.wrr_id = r.id(+)
UNION ALL
select
 'REPLAY' as filter_type,
 NULL as wrr_id,
 'IN SET' as status,
 set_name, filter_name, attribute, value
from wrr$_replay_filter_set rfs
where NOT EXISTS
  (SELECT 1
   FROM   WRR$_REPLAYS r
   WHERE  r.filter_set_name = rfs.set_name
   AND    r.capture_id = rfs.capture_id)

View Text - HTML Formatted

SELECT F.FILTER_TYPE
, DECODE(F.WRR_ID
, 0
, NULL
, F.WRR_ID)
, (CASE WHEN C.STATUS = 'IN PROGRESS' THEN 'IN USE' WHEN F.WRR_ID = 0 THEN 'NEW' ELSE 'USED' END) AS STATUS
, NULL
, F.NAME
, F.ATTRIBUTE
, F.VALUE FROM WRR$_FILTERS F
, WRR$_CAPTURES C WHERE F.WRR_ID = C.ID(+)
AND F.FILTER_TYPE = 'CAPTURE' UNION ALL SELECT F.FILTER_TYPE
, DECODE(F.WRR_ID
, 0
, NULL
, F.WRR_ID)
, (CASE WHEN R.STATUS = 'IN PROGRESS' OR R.STATUS = 'INITIALIZED' OR R.STATUS = 'PREPARE' THEN 'IN USE' WHEN F.WRR_ID = 0 THEN 'NEW' ELSE 'USED' END) AS STATUS
, R.FILTER_SET_NAME
, F.NAME
, F.ATTRIBUTE
, F.VALUE FROM WRR$_FILTERS F
, WRR$_REPLAYS R WHERE F.FILTER_TYPE = 'REPLAY'
AND F.WRR_ID = R.ID(+) UNION ALL SELECT 'REPLAY' AS FILTER_TYPE
, NULL AS WRR_ID
, 'IN SET' AS STATUS
, SET_NAME
, FILTER_NAME
, ATTRIBUTE
, VALUE FROM WRR$_REPLAY_FILTER_SET RFS WHERE NOT EXISTS (SELECT 1
FROM WRR$_REPLAYS R
WHERE R.FILTER_SET_NAME = RFS.SET_NAME
AND R.CAPTURE_ID = RFS.CAPTURE_ID)