VIEW: SYS.V_$SQLAREA_PLAN_HASH

Source

View Text - Preformatted

select "SQL_TEXT","SQL_FULLTEXT","ADDRESS","HASH_VALUE","SQL_ID","PLAN_HASH_VALUE","VERSION_COUNT","LAST_ACTIVE_CHILD_ADDRESS","SHARABLE_MEM","PERSISTENT_MEM","RUNTIME_MEM","SORTS","LOADED_VERSIONS","OPEN_VERSIONS","USERS_OPENING","USERS_EXECUTING","FETCHES","EXECUTIONS","PX_SERVERS_EXECUTIONS","END_OF_FETCH_COUNT","LOADS","FIRST_LOAD_TIME","LAST_LOAD_TIME","LAST_ACTIVE_TIME","INVALIDATIONS","PARSE_CALLS","DISK_READS","DIRECT_WRITES","BUFFER_GETS","CPU_TIME","ELAPSED_TIME","APPLICATION_WAIT_TIME","CONCURRENCY_WAIT_TIME","CLUSTER_WAIT_TIME","USER_IO_WAIT_TIME","PLSQL_EXEC_TIME","JAVA_EXEC_TIME","ROWS_PROCESSED","COMMAND_TYPE","OPTIMIZER_MODE","OPTIMIZER_COST","OPTIMIZER_ENV","OPTIMIZER_ENV_HASH_VALUE","PARSING_USER_ID","PARSING_SCHEMA_ID","PARSING_SCHEMA_NAME","KEPT_VERSIONS","MODULE","MODULE_HASH","ACTION","ACTION_HASH","SERIALIZABLE_ABORTS","OUTLINE_CATEGORY","OUTLINE_SID","REMOTE","OBJECT_STATUS","LITERAL_HASH_VALUE","SQL_PROFILE","PROGRAM_ID","PROGRAM_LINE#","EXACT_MATCHING_SIGNATURE","FORCE_MATCHING_SIGNATURE","BIND_DATA","TYPECHECK_MEM","IO_CELL_OFFLOAD_ELIGIBLE_BYTES","IO_INTERCONNECT_BYTES","PHYSICAL_READ_REQUESTS","PHYSICAL_READ_BYTES","PHYSICAL_WRITE_REQUESTS","PHYSICAL_WRITE_BYTES","OPTIMIZED_PHY_READ_REQUESTS","IO_CELL_UNCOMPRESSED_BYTES","IO_CELL_OFFLOAD_RETURNED_BYTES","CON_ID","CON_DBID" from v$sqlarea_plan_hash

View Text - HTML Formatted

SELECT "SQL_TEXT"
, "SQL_FULLTEXT"
, "ADDRESS"
, "HASH_VALUE"
, "SQL_ID"
, "PLAN_HASH_VALUE"
, "VERSION_COUNT"
, "LAST_ACTIVE_CHILD_ADDRESS"
, "SHARABLE_MEM"
, "PERSISTENT_MEM"
, "RUNTIME_MEM"
, "SORTS"
, "LOADED_VERSIONS"
, "OPEN_VERSIONS"
, "USERS_OPENING"
, "USERS_EXECUTING"
, "FETCHES"
, "EXECUTIONS"
, "PX_SERVERS_EXECUTIONS"
, "END_OF_FETCH_COUNT"
, "LOADS"
, "FIRST_LOAD_TIME"
, "LAST_LOAD_TIME"
, "LAST_ACTIVE_TIME"
, "INVALIDATIONS"
, "PARSE_CALLS"
, "DISK_READS"
, "DIRECT_WRITES"
, "BUFFER_GETS"
, "CPU_TIME"
, "ELAPSED_TIME"
, "APPLICATION_WAIT_TIME"
, "CONCURRENCY_WAIT_TIME"
, "CLUSTER_WAIT_TIME"
, "USER_IO_WAIT_TIME"
, "PLSQL_EXEC_TIME"
, "JAVA_EXEC_TIME"
, "ROWS_PROCESSED"
, "COMMAND_TYPE"
, "OPTIMIZER_MODE"
, "OPTIMIZER_COST"
, "OPTIMIZER_ENV"
, "OPTIMIZER_ENV_HASH_VALUE"
, "PARSING_USER_ID"
, "PARSING_SCHEMA_ID"
, "PARSING_SCHEMA_NAME"
, "KEPT_VERSIONS"
, "MODULE"
, "MODULE_HASH"
, "ACTION"
, "ACTION_HASH"
, "SERIALIZABLE_ABORTS"
, "OUTLINE_CATEGORY"
, "OUTLINE_SID"
, "REMOTE"
, "OBJECT_STATUS"
, "LITERAL_HASH_VALUE"
, "SQL_PROFILE"
, "PROGRAM_ID"
, "PROGRAM_LINE#"
, "EXACT_MATCHING_SIGNATURE"
, "FORCE_MATCHING_SIGNATURE"
, "BIND_DATA"
, "TYPECHECK_MEM"
, "IO_CELL_OFFLOAD_ELIGIBLE_BYTES"
, "IO_INTERCONNECT_BYTES"
, "PHYSICAL_READ_REQUESTS"
, "PHYSICAL_READ_BYTES"
, "PHYSICAL_WRITE_REQUESTS"
, "PHYSICAL_WRITE_BYTES"
, "OPTIMIZED_PHY_READ_REQUESTS"
, "IO_CELL_UNCOMPRESSED_BYTES"
, "IO_CELL_OFFLOAD_RETURNED_BYTES"
, "CON_ID"
, "CON_DBID"
FROM V$SQLAREA_PLAN_HASH