GV$SQLSTATS

select
INST_ID,                 -- INST_ID NUMBER
SQL_TEXT,                -- SQL_TEXT VARCHAR2(1000)
SQL_FULLTEXT,            -- SQL_FULLTEXT CLOB
SQL_ID,                  -- SQL_ID VARCHAR2(13)
LAST_ACTIVE_TIME,        -- LAST_ACTIVE_TIME DATE
LAST_ACTIVE_CHILD_ADDRESS, -- LAST_ACTIVE_CHILD_ADDRESS RAW(4)
PLAN_HASH_VALUE,         -- PLAN_HASH_VALUE NUMBER
PARSE_CALLS,             -- PARSE_CALLS NUMBER
DISK_READS,              -- DISK_READS NUMBER
DIRECT_WRITES,           -- DIRECT_WRITES NUMBER
BUFFER_GETS,             -- BUFFER_GETS NUMBER
ROWS_PROCESSED,          -- ROWS_PROCESSED NUMBER
SERIALIZABLE_ABORTS,     -- SERIALIZABLE_ABORTS NUMBER
FETCHES,                 -- FETCHES NUMBER
EXECUTIONS,              -- EXECUTIONS NUMBER
END_OF_FETCH_COUNT,      -- END_OF_FETCH_COUNT NUMBER
LOADS,                   -- LOADS NUMBER
VERSION_COUNT,           -- VERSION_COUNT NUMBER
INVALIDATIONS,           -- INVALIDATIONS NUMBER
PX_SERVERS_EXECUTIONS,   -- PX_SERVERS_EXECUTIONS NUMBER
CPU_TIME,                -- CPU_TIME NUMBER
ELAPSED_TIME,            -- ELAPSED_TIME NUMBER
APPLICATION_WAIT_TIME,   -- APPLICATION_WAIT_TIME NUMBER
CONCURRENCY_WAIT_TIME,   -- CONCURRENCY_WAIT_TIME NUMBER
CLUSTER_WAIT_TIME,       -- CLUSTER_WAIT_TIME NUMBER
USER_IO_WAIT_TIME,       -- USER_IO_WAIT_TIME NUMBER
PLSQL_EXEC_TIME,         -- PLSQL_EXEC_TIME NUMBER
JAVA_EXEC_TIME,          -- JAVA_EXEC_TIME NUMBER
SORTS,                   -- SORTS NUMBER
SHARABLE_MEM,            -- SHARABLE_MEM NUMBER
TOTAL_SHARABLE_MEM       -- TOTAL_SHARABLE_MEM NUMBER
FROM
x$kkssqlstat
home |  up  |  mailbox