VIEW: SYSTEM.MVIEW_FILTER

Source

View Text - Preformatted

select
      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_filter a, system.mview$_adv_log b, ALL_USERS u
   WHERE a.filterid# = b.runid#
   AND b.uname = u.username
   AND u.user_id = userenv('SCHEMAID')

View Text - HTML Formatted

SELECT 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_FILTER A
, SYSTEM.MVIEW$_ADV_LOG B
, ALL_USERS U
WHERE A.FILTERID# = B.RUNID#
AND B.UNAME = U.USERNAME
AND U.USER_ID = USERENV('SCHEMAID')