DBA_SQLTUNE_STATISTICS displays statistics associated with all SQL statements in the database.
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 | |
MODULEFoot 1 |
VARCHAR2(48) |
Last application module recorded for the SQL | |
ACTIONFootref 1 |
VARCHAR2(32) |
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(1000) |
Optimizer environment | |
COMMAND_TYPE |
NUMBER |
Command type |
Footnote 1 The datatype of this column is VARCHAR2(64) starting with Oracle Database 11g Release 2 (11.2.0.2).
See Also:
"USER_SQLTUNE_STATISTICS"