Name Value
CREATED 27/08/11
LAST_DDL_TIME 27/08/11
OWNER SYSTEM
VIEW_NAME MVIEW_LOG
TEXT_LENGTH 596
TEXT select m.runid# as id, m.filterid# as filterid, m.run_begin, m.run_end, decode(m.run_type,1,'EVALUATE',2,'EVALUATE_W',3,'RECOMMEND', 4,'RECOMMEND_W',5,'VALIDATE',6,'WORKLOAD', 7,'FILTER','UNKNOWN') AS type, decode(m.status,0,'UNUSED',1,'CANCELLED',2,'IN_PROGRESS',3,'COMPLETED', 4,'ERROR','UNKNOWN') AS status, m.message, m.completed, m.total, m.error_code from system.mview$_adv_log m, all_users u where m.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