DBA_ADVISOR_SQLSTATS

DBA_ADVISOR_SQLSTATS displays execution statistics for the test-execution of different SQL plans during the advisor analysis.

Related View

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