[Home] [Help]
[Dependency Information]
[Home] [Help]
[Dependency Information]
| Object Name: | V_$SQL |
|---|---|
| Object Type: | VIEW |
| Owner: | SYS |
| Subobject Name: | |
| Status: | VALID |
| Name | Datatype | Length | Mandatory | Comments |
|---|---|---|---|---|
| SQL_TEXT | VARCHAR2 | (1000) | ||
| SQL_FULLTEXT | CLOB | (4000) | ||
| SQL_ID | VARCHAR2 | (13) | ||
| SHARABLE_MEM | NUMBER | |||
| PERSISTENT_MEM | NUMBER | |||
| RUNTIME_MEM | NUMBER | |||
| SORTS | NUMBER | |||
| LOADED_VERSIONS | NUMBER | |||
| OPEN_VERSIONS | NUMBER | |||
| USERS_OPENING | NUMBER | |||
| FETCHES | NUMBER | |||
| EXECUTIONS | NUMBER | |||
| PX_SERVERS_EXECUTIONS | NUMBER | |||
| END_OF_FETCH_COUNT | NUMBER | |||
| USERS_EXECUTING | NUMBER | |||
| LOADS | NUMBER | |||
| FIRST_LOAD_TIME | VARCHAR2 | (19) | ||
| INVALIDATIONS | NUMBER | |||
| PARSE_CALLS | NUMBER | |||
| DISK_READS | NUMBER | |||
| DIRECT_WRITES | NUMBER | |||
| BUFFER_GETS | 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 | |||
| ADDRESS | RAW | (8) | ||
| TYPE_CHK_HEAP | RAW | (8) | ||
| HASH_VALUE | NUMBER | |||
| OLD_HASH_VALUE | NUMBER | |||
| PLAN_HASH_VALUE | NUMBER | |||
| FULL_PLAN_HASH_VALUE | NUMBER | |||
| CHILD_NUMBER | NUMBER | |||
| SERVICE | VARCHAR2 | (64) | ||
| SERVICE_HASH | NUMBER | |||
| MODULE | VARCHAR2 | (64) | ||
| MODULE_HASH | NUMBER | |||
| ACTION | VARCHAR2 | (64) | ||
| ACTION_HASH | NUMBER | |||
| SERIALIZABLE_ABORTS | NUMBER | |||
| OUTLINE_CATEGORY | VARCHAR2 | (64) | ||
| CPU_TIME | NUMBER | |||
| ELAPSED_TIME | NUMBER | |||
| OUTLINE_SID | NUMBER | |||
| CHILD_ADDRESS | RAW | (8) | ||
| SQLTYPE | NUMBER | |||
| REMOTE | VARCHAR2 | (1) | ||
| OBJECT_STATUS | VARCHAR2 | (19) | ||
| LITERAL_HASH_VALUE | NUMBER | |||
| LAST_LOAD_TIME | VARCHAR2 | (19) | ||
| IS_OBSOLETE | VARCHAR2 | (1) | ||
| IS_BIND_SENSITIVE | VARCHAR2 | (1) | ||
| IS_BIND_AWARE | VARCHAR2 | (1) | ||
| IS_SHAREABLE | VARCHAR2 | (1) | ||
| CHILD_LATCH | NUMBER | |||
| SQL_PROFILE | VARCHAR2 | (64) | ||
| SQL_PATCH | VARCHAR2 | (30) | ||
| SQL_PLAN_BASELINE | VARCHAR2 | (30) | ||
| PROGRAM_ID | NUMBER | |||
| PROGRAM_LINE# | NUMBER | |||
| EXACT_MATCHING_SIGNATURE | NUMBER | |||
| FORCE_MATCHING_SIGNATURE | NUMBER | |||
| LAST_ACTIVE_TIME | DATE | |||
| 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 | |||
| LOCKED_TOTAL | NUMBER | |||
| PINNED_TOTAL | NUMBER | |||
| IO_CELL_UNCOMPRESSED_BYTES | NUMBER | |||
| IO_CELL_OFFLOAD_RETURNED_BYTES | NUMBER | |||
| CON_ID | NUMBER | |||
| IS_REOPTIMIZABLE | VARCHAR2 | (1) | ||
| IS_RESOLVED_ADAPTIVE_PLAN | VARCHAR2 | (1) | ||
| IM_SCANS | NUMBER | |||
| IM_SCAN_BYTES_UNCOMPRESSED | NUMBER | |||
| IM_SCAN_BYTES_INMEMORY | NUMBER |
Cut, paste (and edit) the following text to query this object:
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 SYS.V_$SQL;
PUBLIC
V$SQL
|
|
|
|