Name Value
CREATED 27/08/11
LAST_DDL_TIME 27/08/11
OWNER SYSTEM
VIEW_NAME MVIEW_WORKLOAD
TEXT_LENGTH 436
TEXT select a.collectionid# as workloadid, a.collecttime as import_time, a.queryid# as queryid, a.application, a.cardinality, a.resultsize, a.qdate as lastuse, a.frequency, a.uname as owner, a.priority, a.sql_text as query, a.exec_time as responsetime from SYSTEM.MVIEW$_ADV_WORKLOAD A, SYSTEM.MVIEW$_ADV_LOG B, ALL_USERS D WHERE a.collectionid# = b.runid# AND b.uname = d.username AND d.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