VIEW: SYS.USER_ADVISOR_SQLW_STMTS

Source

View Text - Preformatted

select b.workload_id as workload_id,
             c.name as workload_name,
             b.sql_id as sql_id,
             b.hash_value as hash_value,
             b.username as username,
             substrb(b.module,1,(select ksumodlen from x$modact_length))
             as module,
             substrb(b.action,1,(select ksuactlen from x$modact_length))
             as action,
             b.cpu_time as cpu_time,
             b.buffer_gets as buffer_gets,
             b.disk_reads as disk_reads,
             b.elapsed_time as elapsed_time,
             b.rows_processed as rows_processed,
             b.executions as executions,
             b.optimizer_cost as optimizer_cost,
             b.last_execution_date as last_execution_date,
             b.priority as priority,
             b.command_type as command_type,
             b.stat_period as stat_period,
             b.sql_text as sql_text,
             b.valid as valid
      from wri$_adv_sqlw_stmts b, wri$_adv_tasks c
      where c.id = b.workload_id
        and c.owner# = userenv('SCHEMAID')
        and bitand(c.property,2) = 0
        and c.advisor_id = 6

View Text - HTML Formatted

SELECT B.WORKLOAD_ID AS WORKLOAD_ID
, C.NAME AS WORKLOAD_NAME
, B.SQL_ID AS SQL_ID
, B.HASH_VALUE AS HASH_VALUE
, B.USERNAME AS USERNAME
, SUBSTRB(B.MODULE
, 1
, (SELECT KSUMODLEN
FROM X$MODACT_LENGTH)) AS MODULE
, SUBSTRB(B.ACTION
, 1
, (SELECT KSUACTLEN
FROM X$MODACT_LENGTH)) AS ACTION
, B.CPU_TIME AS CPU_TIME
, B.BUFFER_GETS AS BUFFER_GETS
, B.DISK_READS AS DISK_READS
, B.ELAPSED_TIME AS ELAPSED_TIME
, B.ROWS_PROCESSED AS ROWS_PROCESSED
, B.EXECUTIONS AS EXECUTIONS
, B.OPTIMIZER_COST AS OPTIMIZER_COST
, B.LAST_EXECUTION_DATE AS LAST_EXECUTION_DATE
, B.PRIORITY AS PRIORITY
, B.COMMAND_TYPE AS COMMAND_TYPE
, B.STAT_PERIOD AS STAT_PERIOD
, B.SQL_TEXT AS SQL_TEXT
, B.VALID AS VALID
FROM WRI$_ADV_SQLW_STMTS B
, WRI$_ADV_TASKS C
WHERE C.ID = B.WORKLOAD_ID
AND C.OWNER# = USERENV('SCHEMAID')
AND BITAND(C.PROPERTY
, 2) = 0
AND C.ADVISOR_ID = 6