[Home] [Help] [Dependency Information]
Object Name: | V_$SQLAREA_PLAN_HASH |
---|---|
Object Type: | VIEW |
Owner: | SYS |
Subobject Name: | |
Status: | VALID |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
SQL_TEXT | VARCHAR2 | (1000) | ||
SQL_FULLTEXT | CLOB | (4000) | ||
ADDRESS | RAW | (8) | ||
HASH_VALUE | NUMBER | |||
SQL_ID | VARCHAR2 | (13) | ||
PLAN_HASH_VALUE | NUMBER | |||
VERSION_COUNT | NUMBER | |||
LAST_ACTIVE_CHILD_ADDRESS | RAW | (8) | ||
SHARABLE_MEM | NUMBER | |||
PERSISTENT_MEM | NUMBER | |||
RUNTIME_MEM | NUMBER | |||
SORTS | NUMBER | |||
LOADED_VERSIONS | NUMBER | |||
OPEN_VERSIONS | NUMBER | |||
USERS_OPENING | NUMBER | |||
USERS_EXECUTING | NUMBER | |||
FETCHES | NUMBER | |||
EXECUTIONS | NUMBER | |||
PX_SERVERS_EXECUTIONS | NUMBER | |||
END_OF_FETCH_COUNT | NUMBER | |||
LOADS | NUMBER | |||
FIRST_LOAD_TIME | DATE | |||
LAST_LOAD_TIME | DATE | |||
LAST_ACTIVE_TIME | DATE | |||
INVALIDATIONS | NUMBER | |||
PARSE_CALLS | NUMBER | |||
DISK_READS | NUMBER | |||
DIRECT_WRITES | NUMBER | |||
BUFFER_GETS | NUMBER | |||
CPU_TIME | NUMBER | |||
ELAPSED_TIME | NUMBER | |||
APPLICATION_WAIT_TIME | NUMBER | |||
CONCURRENCY_WAIT_TIME | NUMBER | |||
CLUSTER_WAIT_TIME | NUMBER | |||
USER_IO_WAIT_TIME | NUMBER | |||
PLSQL_EXEC_TIME | NUMBER | |||
JAVA_EXEC_TIME | NUMBER | |||
ROWS_PROCESSED | NUMBER | |||
COMMAND_TYPE | NUMBER | |||
OPTIMIZER_MODE | VARCHAR2 | (10) | ||
OPTIMIZER_COST | NUMBER | |||
OPTIMIZER_ENV | RAW | (2000) | ||
OPTIMIZER_ENV_HASH_VALUE | NUMBER | |||
PARSING_USER_ID | NUMBER | |||
PARSING_SCHEMA_ID | NUMBER | |||
PARSING_SCHEMA_NAME | VARCHAR2 | (30) | ||
KEPT_VERSIONS | NUMBER | |||
MODULE | VARCHAR2 | (64) | ||
MODULE_HASH | NUMBER | |||
ACTION | VARCHAR2 | (64) | ||
ACTION_HASH | NUMBER | |||
SERIALIZABLE_ABORTS | NUMBER | |||
OUTLINE_CATEGORY | VARCHAR2 | (64) | ||
OUTLINE_SID | VARCHAR2 | (40) | ||
REMOTE | VARCHAR2 | (1) | ||
OBJECT_STATUS | VARCHAR2 | (19) | ||
LITERAL_HASH_VALUE | NUMBER | |||
SQL_PROFILE | VARCHAR2 | (64) | ||
PROGRAM_ID | NUMBER | |||
PROGRAM_LINE# | NUMBER | |||
EXACT_MATCHING_SIGNATURE | NUMBER | |||
FORCE_MATCHING_SIGNATURE | NUMBER | |||
BIND_DATA | RAW | (2000) | ||
TYPECHECK_MEM | NUMBER | |||
IO_CELL_OFFLOAD_ELIGIBLE_BYTES | NUMBER | |||
IO_INTERCONNECT_BYTES | NUMBER | |||
PHYSICAL_READ_REQUESTS | NUMBER | |||
PHYSICAL_READ_BYTES | NUMBER | |||
PHYSICAL_WRITE_REQUESTS | NUMBER | |||
PHYSICAL_WRITE_BYTES | NUMBER | |||
OPTIMIZED_PHY_READ_REQUESTS | NUMBER | |||
IO_CELL_UNCOMPRESSED_BYTES | NUMBER | |||
IO_CELL_OFFLOAD_RETURNED_BYTES | NUMBER | |||
CON_ID | NUMBER | |||
CON_DBID | NUMBER |
Cut, paste (and edit) the following text to query this object:
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 SYS.V_$SQLAREA_PLAN_HASH;
|
|
|