Name Value
CREATED 27/08/11
LAST_DDL_TIME 27/08/11
OWNER SYSTEM
VIEW_NAME MVIEW_FILTER
TEXT_LENGTH 763
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')
TYPE_TEXT_LENGTH null
TYPE_TEXT null
OID_TEXT_LENGTH null
OID_TEXT null
VIEW_TYPE_OWNER null
VIEW_TYPE null
SUPERVIEW_NAME null
EDITIONING_VIEW N
READ_ONLY N