VIEW: SYS.V_$SQL

Source

View Text - Preformatted

select "SQL_TEXT","SQL_FULLTEXT","SQL_ID","SHARABLE_MEM","PERSISTENT_MEM","RUNTIME_MEM","SORTS","LOADED_VERSIONS","OPEN_VERSIONS","USERS_OPENING","FETCHES","EXECUTIONS","PX_SERVERS_EXECUTIONS","END_OF_FETCH_COUNT","USERS_EXECUTING","LOADS","FIRST_LOAD_TIME","INVALIDATIONS","PARSE_CALLS","DISK_READS","DIRECT_WRITES","BUFFER_GETS","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","ADDRESS","TYPE_CHK_HEAP","HASH_VALUE","OLD_HASH_VALUE","PLAN_HASH_VALUE","FULL_PLAN_HASH_VALUE","CHILD_NUMBER","SERVICE","SERVICE_HASH","MODULE","MODULE_HASH","ACTION","ACTION_HASH","SERIALIZABLE_ABORTS","OUTLINE_CATEGORY","CPU_TIME","ELAPSED_TIME","OUTLINE_SID","CHILD_ADDRESS","SQLTYPE","REMOTE","OBJECT_STATUS","LITERAL_HASH_VALUE","LAST_LOAD_TIME","IS_OBSOLETE","IS_BIND_SENSITIVE","IS_BIND_AWARE","IS_SHAREABLE","CHILD_LATCH","SQL_PROFILE","SQL_PATCH","SQL_PLAN_BASELINE","PROGRAM_ID","PROGRAM_LINE#","EXACT_MATCHING_SIGNATURE","FORCE_MATCHING_SIGNATURE","LAST_ACTIVE_TIME","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","LOCKED_TOTAL","PINNED_TOTAL","IO_CELL_UNCOMPRESSED_BYTES","IO_CELL_OFFLOAD_RETURNED_BYTES","CON_ID","IS_REOPTIMIZABLE","IS_RESOLVED_ADAPTIVE_PLAN","IM_SCANS","IM_SCAN_BYTES_UNCOMPRESSED","IM_SCAN_BYTES_INMEMORY" from v$sql

View Text - HTML Formatted

SELECT "SQL_TEXT"
, "SQL_FULLTEXT"
, "SQL_ID"
, "SHARABLE_MEM"
, "PERSISTENT_MEM"
, "RUNTIME_MEM"
, "SORTS"
, "LOADED_VERSIONS"
, "OPEN_VERSIONS"
, "USERS_OPENING"
, "FETCHES"
, "EXECUTIONS"
, "PX_SERVERS_EXECUTIONS"
, "END_OF_FETCH_COUNT"
, "USERS_EXECUTING"
, "LOADS"
, "FIRST_LOAD_TIME"
, "INVALIDATIONS"
, "PARSE_CALLS"
, "DISK_READS"
, "DIRECT_WRITES"
, "BUFFER_GETS"
, "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"
, "ADDRESS"
, "TYPE_CHK_HEAP"
, "HASH_VALUE"
, "OLD_HASH_VALUE"
, "PLAN_HASH_VALUE"
, "FULL_PLAN_HASH_VALUE"
, "CHILD_NUMBER"
, "SERVICE"
, "SERVICE_HASH"
, "MODULE"
, "MODULE_HASH"
, "ACTION"
, "ACTION_HASH"
, "SERIALIZABLE_ABORTS"
, "OUTLINE_CATEGORY"
, "CPU_TIME"
, "ELAPSED_TIME"
, "OUTLINE_SID"
, "CHILD_ADDRESS"
, "SQLTYPE"
, "REMOTE"
, "OBJECT_STATUS"
, "LITERAL_HASH_VALUE"
, "LAST_LOAD_TIME"
, "IS_OBSOLETE"
, "IS_BIND_SENSITIVE"
, "IS_BIND_AWARE"
, "IS_SHAREABLE"
, "CHILD_LATCH"
, "SQL_PROFILE"
, "SQL_PATCH"
, "SQL_PLAN_BASELINE"
, "PROGRAM_ID"
, "PROGRAM_LINE#"
, "EXACT_MATCHING_SIGNATURE"
, "FORCE_MATCHING_SIGNATURE"
, "LAST_ACTIVE_TIME"
, "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"
, "LOCKED_TOTAL"
, "PINNED_TOTAL"
, "IO_CELL_UNCOMPRESSED_BYTES"
, "IO_CELL_OFFLOAD_RETURNED_BYTES"
, "CON_ID"
, "IS_REOPTIMIZABLE"
, "IS_RESOLVED_ADAPTIVE_PLAN"
, "IM_SCANS"
, "IM_SCAN_BYTES_UNCOMPRESSED"
, "IM_SCAN_BYTES_INMEMORY"
FROM V$SQL