| Oracle® Database Reference 11g Release 1 (11.1) Part Number B28320-01 |
|
|
View PDF |
| Oracle® Database Reference 11g Release 1 (11.1) Part Number B28320-01 |
|
|
View PDF |
DBA_ADVISOR_SQLSTATS displays a list of all SQL compilation and execution statistics.
Related View
USER_ADVISOR_SQLSTATSdisplays a list of all SQL compilation and execution statistics owned by the current user.
| Column | Datatype | NULL | Description |
|---|---|---|---|
TASK_NAME |
VARCHAR2(30) |
??? | |
TASK_ID |
NUMBER(38) |
NOT NULL |
??? |
EXECUTION_NAME |
VARCHAR2(30) |
NOT NULL |
The name of the task execution with which this entry (row) is associated |
EXECUTION_TYPE |
VARCHAR2(30) |
Type of the last execution. This information is optional for single-execution tasks. | |
OBJECT_ID |
NUMBER(38) |
NOT NULL |
??? |
PLAN_ID |
NUMBER |
NOT NULL |
??? |
SQL_ID |
VARCHAR2(13) |
NOT NULL |
??? |
PLAN_HASH_VALUE |
NUMBER |
NOT NULL |
??? |
PARSE_TIME |
NUMBER |
??? | |
EXECUTE_ELAPSED_TIME |
NUMBER |
??? | |
ELAPSED_TIME |
NUMBER |
??? | |
EXECUTE_CPU_TIME |
NUMBER |
??? | |
BUFFER_GETS |
NUMBER |
??? | |
DISK_READS |
NUMBER |
??? | |
DIRECT_WRITES |
NUMBER |
??? | |
ROWS_PROCESSED |
NUMBER |
??? | |
FETCHES |
NUMBER |
??? | |
EXECUTIONS |
NUMBER |
??? | |
END_OF_FETCH_COUNT |
NUMBER |
??? | |
OPTIMIZER_COST |
NUMBER |
??? | |
OTHER |
CLOB |
??? |
