DBA_SQLSET_STATEMENTS

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
`COMMAND_TYPE`	`NUMBER`		Command type
`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

See Also:

"USER_SQLSET_STATEMENTS"