VIEW: SYS._ALL_SQLSET_STATISTICS_ONLY

Source

View Text - Preformatted

SELECT stmts.sqlset_id, stmts.con_dbid, stat.stmt_id sql_seq,
         stat.plan_hash_value,
         stat.elapsed_time, stat.cpu_time, stat.buffer_gets, stat.disk_reads,
         stat.direct_writes, stat.rows_processed, stat.fetches, stat.executions,
         stat.end_of_fetch_count, stat.optimizer_cost, stat.first_load_time,
         stat.stat_period,
         stat.active_stat_period,
         plns.plan_timestamp, plns.binds_captured
  FROM   WRI$_SQLSET_STATISTICS stat, WRI$_SQLSET_STATEMENTS stmts,
         WRI$_SQLSET_PLANS plns, WRI$_SQLSET_DEFINITIONS defns
  WHERE  defns.id = stmts.sqlset_id AND
         stat.stmt_id = stmts.id AND
         stat.plan_hash_value = plns.plan_hash_value AND
         stat.stmt_id = plns.stmt_id  AND
         (defns.owner = SYS_CONTEXT('USERENV', 'CURRENT_USER') OR
          EXISTS(SELECT 1
                 FROM v$enabledprivs
                 WHERE priv_number = -273))

View Text - HTML Formatted

SELECT STMTS.SQLSET_ID
, STMTS.CON_DBID
, STAT.STMT_ID SQL_SEQ
, STAT.PLAN_HASH_VALUE
, STAT.ELAPSED_TIME
, STAT.CPU_TIME
, STAT.BUFFER_GETS
, STAT.DISK_READS
, STAT.DIRECT_WRITES
, STAT.ROWS_PROCESSED
, STAT.FETCHES
, STAT.EXECUTIONS
, STAT.END_OF_FETCH_COUNT
, STAT.OPTIMIZER_COST
, STAT.FIRST_LOAD_TIME
, STAT.STAT_PERIOD
, STAT.ACTIVE_STAT_PERIOD
, PLNS.PLAN_TIMESTAMP
, PLNS.BINDS_CAPTURED
FROM WRI$_SQLSET_STATISTICS STAT
, WRI$_SQLSET_STATEMENTS STMTS
, WRI$_SQLSET_PLANS PLNS
, WRI$_SQLSET_DEFINITIONS DEFNS
WHERE DEFNS.ID = STMTS.SQLSET_ID AND STAT.STMT_ID = STMTS.ID AND STAT.PLAN_HASH_VALUE = PLNS.PLAN_HASH_VALUE AND STAT.STMT_ID = PLNS.STMT_ID AND (DEFNS.OWNER = SYS_CONTEXT('USERENV'
, 'CURRENT_USER') OR EXISTS(SELECT 1
FROM V$ENABLEDPRIVS
WHERE PRIV_NUMBER = -273))