[Home] [Help] [Dependency Information]
Object Name: | V_$SQLSTATS |
---|---|
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) | ||
LAST_ACTIVE_TIME | DATE | |||
LAST_ACTIVE_CHILD_ADDRESS | RAW | (8) | ||
PLAN_HASH_VALUE | NUMBER | |||
PARSE_CALLS | NUMBER | |||
DISK_READS | NUMBER | |||
DIRECT_WRITES | NUMBER | |||
BUFFER_GETS | NUMBER | |||
ROWS_PROCESSED | NUMBER | |||
SERIALIZABLE_ABORTS | NUMBER | |||
FETCHES | NUMBER | |||
EXECUTIONS | NUMBER | |||
END_OF_FETCH_COUNT | NUMBER | |||
LOADS | NUMBER | |||
VERSION_COUNT | NUMBER | |||
INVALIDATIONS | NUMBER | |||
PX_SERVERS_EXECUTIONS | NUMBER | |||
CPU_TIME | NUMBER | |||
ELAPSED_TIME | NUMBER | |||
AVG_HARD_PARSE_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 | |||
SORTS | NUMBER | |||
SHARABLE_MEM | NUMBER | |||
TOTAL_SHARABLE_MEM | NUMBER | |||
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 | |||
EXACT_MATCHING_SIGNATURE | NUMBER | |||
FORCE_MATCHING_SIGNATURE | NUMBER | |||
IO_CELL_UNCOMPRESSED_BYTES | NUMBER | |||
IO_CELL_OFFLOAD_RETURNED_BYTES | NUMBER | |||
DELTA_PARSE_CALLS | NUMBER | |||
DELTA_DISK_READS | NUMBER | |||
DELTA_DIRECT_WRITES | NUMBER | |||
DELTA_BUFFER_GETS | NUMBER | |||
DELTA_ROWS_PROCESSED | NUMBER | |||
DELTA_FETCH_COUNT | NUMBER | |||
DELTA_EXECUTION_COUNT | NUMBER | |||
DELTA_PX_SERVERS_EXECUTIONS | NUMBER | |||
DELTA_END_OF_FETCH_COUNT | NUMBER | |||
DELTA_CPU_TIME | NUMBER | |||
DELTA_ELAPSED_TIME | NUMBER | |||
DELTA_APPLICATION_WAIT_TIME | NUMBER | |||
DELTA_CONCURRENCY_TIME | NUMBER | |||
DELTA_CLUSTER_WAIT_TIME | NUMBER | |||
DELTA_USER_IO_WAIT_TIME | NUMBER | |||
DELTA_PLSQL_EXEC_TIME | NUMBER | |||
DELTA_JAVA_EXEC_TIME | NUMBER | |||
DELTA_SORTS | NUMBER | |||
DELTA_LOADS | NUMBER | |||
DELTA_INVALIDATIONS | NUMBER | |||
DELTA_PHYSICAL_READ_REQUESTS | NUMBER | |||
DELTA_PHYSICAL_READ_BYTES | NUMBER | |||
DELTA_PHYSICAL_WRITE_REQUESTS | NUMBER | |||
DELTA_PHYSICAL_WRITE_BYTES | NUMBER | |||
DELTA_IO_INTERCONNECT_BYTES | NUMBER | |||
DELTA_CELL_OFFLOAD_ELIG_BYTES | NUMBER | |||
DELTA_CELL_UNCOMPRESSED_BYTES | NUMBER | |||
CON_ID | NUMBER | |||
CON_DBID | NUMBER | |||
OBSOLETE_COUNT | NUMBER |
Cut, paste (and edit) the following text to query this object:
SELECT SQL_TEXT
, SQL_FULLTEXT
, SQL_ID
, LAST_ACTIVE_TIME
, LAST_ACTIVE_CHILD_ADDRESS
, PLAN_HASH_VALUE
, PARSE_CALLS
, DISK_READS
, DIRECT_WRITES
, BUFFER_GETS
, ROWS_PROCESSED
, SERIALIZABLE_ABORTS
, FETCHES
, EXECUTIONS
, END_OF_FETCH_COUNT
, LOADS
, VERSION_COUNT
, INVALIDATIONS
, PX_SERVERS_EXECUTIONS
, CPU_TIME
, ELAPSED_TIME
, AVG_HARD_PARSE_TIME
, APPLICATION_WAIT_TIME
, CONCURRENCY_WAIT_TIME
, CLUSTER_WAIT_TIME
, USER_IO_WAIT_TIME
, PLSQL_EXEC_TIME
, JAVA_EXEC_TIME
, SORTS
, SHARABLE_MEM
, TOTAL_SHARABLE_MEM
, TYPECHECK_MEM
, IO_CELL_OFFLOAD_ELIGIBLE_BYTES
, IO_INTERCONNECT_BYTES
, PHYSICAL_READ_REQUESTS
, PHYSICAL_READ_BYTES
, PHYSICAL_WRITE_REQUESTS
, PHYSICAL_WRITE_BYTES
, EXACT_MATCHING_SIGNATURE
, FORCE_MATCHING_SIGNATURE
, IO_CELL_UNCOMPRESSED_BYTES
, IO_CELL_OFFLOAD_RETURNED_BYTES
, DELTA_PARSE_CALLS
, DELTA_DISK_READS
, DELTA_DIRECT_WRITES
, DELTA_BUFFER_GETS
, DELTA_ROWS_PROCESSED
, DELTA_FETCH_COUNT
, DELTA_EXECUTION_COUNT
, DELTA_PX_SERVERS_EXECUTIONS
, DELTA_END_OF_FETCH_COUNT
, DELTA_CPU_TIME
, DELTA_ELAPSED_TIME
, DELTA_APPLICATION_WAIT_TIME
, DELTA_CONCURRENCY_TIME
, DELTA_CLUSTER_WAIT_TIME
, DELTA_USER_IO_WAIT_TIME
, DELTA_PLSQL_EXEC_TIME
, DELTA_JAVA_EXEC_TIME
, DELTA_SORTS
, DELTA_LOADS
, DELTA_INVALIDATIONS
, DELTA_PHYSICAL_READ_REQUESTS
, DELTA_PHYSICAL_READ_BYTES
, DELTA_PHYSICAL_WRITE_REQUESTS
, DELTA_PHYSICAL_WRITE_BYTES
, DELTA_IO_INTERCONNECT_BYTES
, DELTA_CELL_OFFLOAD_ELIG_BYTES
, DELTA_CELL_UNCOMPRESSED_BYTES
, CON_ID
, CON_DBID
, OBSOLETE_COUNT
FROM SYS.V_$SQLSTATS;
|
|
|