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

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

Go to previous page
Previous
Go to next page
Next
PDF · Mobi · ePub

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
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).