select
a.runid# as runid,
a.filterid# as filterid,
a.subfilternum# as subfilternum,
decode(a.subfiltertype,1,'APPLICATION',2,'CARDINALITY',3,'LASTUSE',
4,'FREQUENCY',5,'USER',6,'PRIORITY',7,'BASETABLE',
8,'RESPONSETIME',9,'COLLECTIONID',10,'TRACENAME',
11,'SCHEMA','UNKNOWN') AS subfiltertype,
a.str_value,
to_number(decode(a.num_value1,-999,NULL,a.num_value1)) AS num_value1,
to_number(decode(a.num_value2,-999,NULL,a.num_value2)) AS num_value2,
a.date_value1,
a.date_value2
from system.mview$_adv_filterinstance a
SELECT
A.RUNID# AS RUNID
,
A.FILTERID# AS FILTERID
,
A.SUBFILTERNUM# AS SUBFILTERNUM
,
DECODE(A.SUBFILTERTYPE
, 1
, 'APPLICATION'
, 2
, 'CARDINALITY'
, 3
, 'LASTUSE'
,
4
, 'FREQUENCY'
, 5
, 'USER'
, 6
, 'PRIORITY'
, 7
, 'BASETABLE'
,
8
, 'RESPONSETIME'
, 9
, 'COLLECTIONID'
, 10
, 'TRACENAME'
,
11
, 'SCHEMA'
, 'UNKNOWN') AS SUBFILTERTYPE
,
A.STR_VALUE
,
TO_NUMBER(DECODE(A.NUM_VALUE1
, -999
, NULL
, A.NUM_VALUE1)) AS NUM_VALUE1
,
TO_NUMBER(DECODE(A.NUM_VALUE2
, -999
, NULL
, A.NUM_VALUE2)) AS NUM_VALUE2
,
A.DATE_VALUE1
,
A.DATE_VALUE2
FROM SYSTEM.MVIEW$_ADV_FILTERINSTANCE A
|
|
|