TEXT |
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') |