DBA_SQLTUNE_STATISTICS

DBA_SQLTUNE_STATISTICS displays statistics associated with all SQL statements in the database.

Related View

USER_SQLTUNE_STATISTICS displays statistics associated with the SQL statements owned by the current user.


Column Datatype NULL Description

TASK_ID

NUMBER(38)

NOT NULL

Tuning task identifier

OBJECT_ID

NUMBER(38)

NOT NULL

Advisor framework object identifier

PARSING_SCHEMA_ID

NUMBER

 

Schema under which the SQL is parsed

MODULE

VARCHAR2(64)

 

Last application module recorded for the SQL

ACTION

VARCHAR2(64)

 

Last application action recorded for the SQL

ELAPSED_TIME

NUMBER

 

Elapsed time for the SQL statement

CPU_TIME

NUMBER

 

CPU time for the SQL

BUFFER_GETS

NUMBER

 

Number of buffer gets

DISK_READS

NUMBER

 

Number of disk reads

DIRECT_WRITES

NUMBER

 

Number of disk writes

ROWS_PROCESSED

NUMBER

 

Number of rows processed by the SQL

FETCHES

NUMBER

 

Number of fetches

EXECUTIONS

NUMBER

 

Number of executions

END_OF_FETCH_COUNT

NUMBER

 

End of fetch count

OPTIMIZER_COST

NUMBER

 

Optimizer cost for the SQL

OPTIMIZER_ENV

RAW(2000)

 

Optimizer environment

COMMAND_TYPE

NUMBER

 

Command type