Skip Headers

Oracle® Database Reference
10g Release 1 (10.1)

Part Number B10755-01
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

Go to previous page
Go to next page
View PDF


DBA_SQLSET_STATEMENTS displays information about the SQL statements, along with their statistics, that form all SQL tuning sets in the database.

Related View

USER_SQLSET_STATEMENTS displays information about the SQL statements, along with their statistics, that form the SQL tuning sets owned by the current user.

Column Datatype NULL Description
SQLSET_ID NUMBER NOT NULL SQL tuning set identifier
SQL_ID VARCHAR2(13) NOT NULL SQL identifier of the SQL statement
SQL_TEXT CLOB   Text of the SQL statement
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
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
PRIORITY NUMBER   User-defined priority
STAT_PERIOD NUMBER   Period of time (in seconds) during which the statistics of the SQL statement were collected
ACTIVE_STAT_PERIOD NUMBER   Effective period of time (in seconds) during which the SQL statement was active