Name Value
CREATED 27/08/11
LAST_DDL_TIME 27/08/11
OWNER SYSTEM
VIEW_NAME MVIEW_FILTERINSTANCE
TEXT_LENGTH 659
TEXT 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
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