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 |