DBA_SQLTUNE_STATISTICS

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

See Also:

"USER_SQLTUNE_STATISTICS"