[Home] [Help] [Dependency Information]
Object Name: | V_$SQLXS |
---|---|
Object Type: | VIEW |
Owner: | SYS |
Subobject Name: | |
Status: | VALID |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
SQL_TEXT | VARCHAR2 | (1000) | ||
SHARABLE_MEM | NUMBER | |||
SORTS | NUMBER | |||
MODULE | VARCHAR2 | (64) | ||
LOADED_VERSIONS | NUMBER | |||
EXECUTIONS | NUMBER | |||
LOADS | NUMBER | |||
INVALIDATIONS | NUMBER | |||
PARSE_CALLS | NUMBER | |||
DISK_READS | NUMBER | |||
BUFFER_GETS | NUMBER | |||
ROWS_PROCESSED | NUMBER | |||
ADDRESS | RAW | (8) | ||
HASH_VALUE | NUMBER | |||
VERSION_COUNT | NUMBER |
Cut, paste (and edit) the following text to query this object:
SELECT SQL_TEXT
, SHARABLE_MEM
, SORTS
, MODULE
, LOADED_VERSIONS
, EXECUTIONS
, LOADS
, INVALIDATIONS
, PARSE_CALLS
, DISK_READS
, BUFFER_GETS
, ROWS_PROCESSED
, ADDRESS
, HASH_VALUE
, VERSION_COUNT
FROM SYS.V_$SQLXS;
|
|
|