select
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(8)
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
AVG_HARD_PARSE_TIME, -- AVG_HARD_PARSE_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
TYPECHECK_MEM, -- TYPECHECK_MEM NUMBER
IO_CELL_OFFLOAD_ELIGIBLE_BYTES, -- IO_CELL_OFFLOAD_ELIGIBLE_BYTES NUMBER
IO_INTERCONNECT_BYTES, -- IO_INTERCONNECT_BYTES NUMBER
PHYSICAL_READ_REQUESTS, -- PHYSICAL_READ_REQUESTS NUMBER
PHYSICAL_READ_BYTES, -- PHYSICAL_READ_BYTES NUMBER
PHYSICAL_WRITE_REQUESTS, -- PHYSICAL_WRITE_REQUESTS NUMBER
PHYSICAL_WRITE_BYTES, -- PHYSICAL_WRITE_BYTES NUMBER
EXACT_MATCHING_SIGNATURE, -- EXACT_MATCHING_SIGNATURE NUMBER
FORCE_MATCHING_SIGNATURE, -- FORCE_MATCHING_SIGNATURE NUMBER
IO_CELL_UNCOMPRESSED_BYTES, -- IO_CELL_UNCOMPRESSED_BYTES NUMBER
IO_CELL_OFFLOAD_RETURNED_BYTES -- IO_CELL_OFFLOAD_RETURNED_BYTES NUMBER
FROM
gv$sqlstats
where
inst_id=USERENV('Instance')