[Home] [Help] [Dependency Information]
Object Name: | USER_ADVISOR_SQLSTATS |
---|---|
Object Type: | VIEW |
Owner: | SYS |
Subobject Name: | |
Status: | VALID |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
TASK_NAME | VARCHAR2 | (128) | ||
TASK_ID | NUMBER | (38) | Yes | |
EXECUTION_NAME | VARCHAR2 | (128) | Yes | |
EXECUTION_TYPE | VARCHAR2 | (30) | ||
OBJECT_ID | NUMBER | (38) | Yes | |
PLAN_ID | NUMBER | Yes | ||
SQL_ID | VARCHAR2 | (13) | Yes | |
PLAN_HASH_VALUE | NUMBER | Yes | ||
ATTR1 | NUMBER | |||
PARSE_TIME | NUMBER | |||
ELAPSED_TIME | NUMBER | |||
CPU_TIME | NUMBER | |||
USER_IO_TIME | NUMBER | |||
BUFFER_GETS | NUMBER | |||
DISK_READS | NUMBER | |||
DIRECT_WRITES | NUMBER | |||
PHYSICAL_READ_REQUESTS | NUMBER | |||
PHYSICAL_WRITE_REQUESTS | NUMBER | |||
PHYSICAL_READ_BYTES | NUMBER | |||
PHYSICAL_WRITE_BYTES | NUMBER | |||
ROWS_PROCESSED | NUMBER | |||
FETCHES | NUMBER | |||
EXECUTIONS | NUMBER | |||
END_OF_FETCH_COUNT | NUMBER | |||
OPTIMIZER_COST | NUMBER | |||
OTHER | CLOB | (4000) | ||
TESTEXEC_TOTAL_EXECS | NUMBER | |||
IO_INTERCONNECT_BYTES | NUMBER | |||
TESTEXEC_FIRST_EXEC_IGNORED | VARCHAR2 | (1) | ||
CON_DBID | NUMBER | Yes |
Cut, paste (and edit) the following text to query this object:
SELECT TASK_NAME
, TASK_ID
, EXECUTION_NAME
, EXECUTION_TYPE
, OBJECT_ID
, PLAN_ID
, SQL_ID
, PLAN_HASH_VALUE
, ATTR1
, PARSE_TIME
, ELAPSED_TIME
, CPU_TIME
, USER_IO_TIME
, BUFFER_GETS
, DISK_READS
, DIRECT_WRITES
, PHYSICAL_READ_REQUESTS
, PHYSICAL_WRITE_REQUESTS
, PHYSICAL_READ_BYTES
, PHYSICAL_WRITE_BYTES
, ROWS_PROCESSED
, FETCHES
, EXECUTIONS
, END_OF_FETCH_COUNT
, OPTIMIZER_COST
, OTHER
, TESTEXEC_TOTAL_EXECS
, IO_INTERCONNECT_BYTES
, TESTEXEC_FIRST_EXEC_IGNORED
, CON_DBID
FROM SYS.USER_ADVISOR_SQLSTATS;
|
|
|