DBA_ADVISOR_SQLSTATS displays execution statistics for the test-execution of different SQL plans during the advisor analysis.
USER_ADVISOR_SQLSTATS displays execution statistics owned by the current user for the test-execution of different SQL plans during the advisor analysis.
| Column | Datatype | NULL | Description |
|---|---|---|---|
TASK_NAME |
VARCHAR2(30) |
Advisor task name in which the SQL statement was executed (see DBA_ADVISOR_TASKS) |
|
TASK_ID |
NUMBER(38) |
NOT NULL |
Advisor task ID in which the SQL statement was executed (see DBA_ADVISOR_TASKS) |
EXECUTION_NAME |
VARCHAR2(30) |
NOT NULL |
Advisor task execution in which the SQL statement was executed (see DBA_ADVISOR_EXECUTIONS) |
EXECUTION_TYPE |
VARCHAR2(30) |
Type of the advisor task execution in which the SQL statement was executed (see DBA_ADVISOR_EXECUTIONS) |
|
OBJECT_ID |
NUMBER(38) |
NOT NULL |
Advisor object ID identifying the relevant SQL statement (see DBA_ADVISOR_OBJECTS) |
PLAN_ID |
NUMBER |
NOT NULL |
Plan ID number generated to uniquely identify a plan for a particular SQL statement (foreign key to DBA_ADVISOR_SQLPLANS) |
SQL_ID |
VARCHAR2(13) |
NOT NULL |
Identifier for the SQL statement executed |
PLAN_HASH_VALUE |
NUMBER |
NOT NULL |
Hash value of the SQL execution plan |
PARSE_TIME |
NUMBER |
Parse time (in milliseconds) measured for the SQL | |
ELAPSED_TIME |
NUMBER |
Elapsed time (in milliseconds) to execute the SQL and fetch all of its rows, after parsing | |
CPU_TIME |
NUMBER |
CPU time (in milliseconds) to execute the SQL and fetch all of its rows, after parsing | |
USER_IO_TIME |
NUMBER |
I/O time (in milliseconds) to execute the SQL and fetch all of its rows, after parsing | |
BUFFER_GETS |
NUMBER |
Number of buffer gets measured for executing the SQL and fetching all of its rows | |
DISK_READS |
NUMBER |
Number of disk reads measured for executing the SQL and fetching all of its rows | |
DIRECT_WRITES |
NUMBER |
Number of direct writes measured for executing the SQL and fetching all of its rows | |
ROWS_PROCESSED |
NUMBER |
Number of rows returned by the SQL execution | |
FETCHES |
NUMBER |
Number of fetches for the SQL execution | |
EXECUTIONS |
NUMBER |
Execution count for the SQL. This column will always have a value of 1 or 0. |
|
END_OF_FETCH_COUNT |
NUMBER |
Indicates whether the SQL was executed to end-of-fetch (1) or not (0) |
|
OPTIMIZER_COST |
NUMBER |
Optimizer cost for the execution plan | |
OTHER |
CLOB |
Reserved for future use |