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 |
---|---|---|---|
|
|
|
Tuning task identifier |
|
|
|
Advisor framework object identifier |
|
|
Schema under which the SQL is parsed |
|
|
|
Last application module recorded for the SQL |
|
|
|
Last application action recorded for the SQL |
|
|
|
Elapsed time for the SQL statement |
|
|
|
CPU time for the SQL |
|
|
|
Number of buffer gets |
|
|
|
Number of disk reads |
|
|
|
Number of disk writes |
|
|
|
Number of rows processed by the SQL |
|
|
|
Number of fetches |
|
|
|
Number of executions |
|
|
|
End of fetch count |
|
|
|
Optimizer cost for the SQL |
|
|
|
Optimizer environment |
|
|
|
Command type |
See Also: