DBA Data[Home] [Help] [Dependency Information]

VIEW: SYS.V_$SQLAREA_PLAN_HASH

Object Details
Object Name: V_$SQLAREA_PLAN_HASH
Object Type: VIEW
Owner: SYS
Subobject Name:
Status: VALID

[View Source]

Columns
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

Query Text

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;

Dependencies

[top of page]

SYS.V_$SQLAREA_PLAN_HASH references the following:

SYS.V_$SQLAREA_PLAN_HASH is referenced by following:

SchemaPUBLIC
SynonymV$SQLAREA_PLAN_HASH