4.39 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(128)

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(128)

NOT NULL

Advisor task execution in which the SQL statement was executed (see DBA_ADVISOR_EXECUTIONS)

EXECUTION_TYPE

VARCHAR2(128)

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

ATTR1

NUMBER

For internal use only

CON_DBID

NUMBER

The database ID of the pluggable database (PDB)

PARSE_TIME

NUMBER

Parse time (in microseconds) measured for the SQL

ELAPSED_TIME

NUMBER

Elapsed time (in microseconds) to execute the SQL and fetch all of its rows, after parsing

CPU_TIME

NUMBER

CPU time (in microseconds) to execute the SQL and fetch all of its rows, after parsing

USER_IO_TIME

NUMBER

I/O time (in microseconds) 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

PHYSICAL_READ_REQUESTS

NUMBER

Number of physical read I/O requests issued by the monitored SQL

PHYSICAL_WRITE_REQUESTS

NUMBER

Number of physical write I/O requests issued by the monitored SQL

PHYSICAL_READ_BYTES

NUMBER

Number of bytes read from disks by the monitored SQL

PHYSICAL_WRITE_BYTES

NUMBER

Number of bytes written to disks by the monitored SQL

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

For internal use only

TESTEXEC_TOTAL_EXECS

NUMBER

Total number of executions during test execute

IO_INTERCONNECT_BYTES

NUMBER

Number of I/O bytes exchanged between Oracle Database and the storage system

TESTEXEC_FIRST_EXEC_IGNORED

VARCHAR2(1)

Indicates whether the first execution in test execute is ignored (Y) or not (N)

CON_DBID

NUMBER

The database ID of the PDB

ATTR2

NUMBER

For internal use only

ATTR3

NUMBER

For internal use only

CACHED_GETS

NUMBER

The total of the db block gets from cache statistic and the consistent gets from cache statistic

DIRECT_GETS

NUMBER

The total of the db block gets direct statistic and the consistent gets direct statistic

See Also: