Skip Headers
Oracle® Database Reference
11g Release 2 (11.2)

Part Number E10820-03
Go to Documentation Home
Go to Book List
Book List
Go to Table of Contents
Go to Index
Go to Master Index
Master Index
Go to Feedback page
Contact Us

Go to previous page
Go to next page
View PDF


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(48)   Last application module recorded for the SQL
ACTION 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