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')
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')
|
|
|