DBA Data[Home] [Help]
Skip to content

VIEW: SYS.CDB_SQLTUNE_STATISTICS

Source

View Text - Preformatted

SELECT "TASK_ID","OBJECT_ID","PARSING_SCHEMA_ID","MODULE","ACTION","ELAPSED_TIME","CPU_TIME","BUFFER_GETS","DISK_READS","DIRECT_WRITES","ROWS_PROCESSED","FETCHES","EXECUTIONS","END_OF_FETCH_COUNT","OPTIMIZER_COST","OPTIMIZER_ENV","COMMAND_TYPE","CON_ID" FROM CONTAINERS("SYS"."DBA_SQLTUNE_STATISTICS")
View Text - HTML Formatted

SELECT "TASK_ID"
, "OBJECT_ID"
, "PARSING_SCHEMA_ID"
, "MODULE"
, "ACTION"
, "ELAPSED_TIME"
, "CPU_TIME"
, "BUFFER_GETS"
, "DISK_READS"
, "DIRECT_WRITES"
, "ROWS_PROCESSED"
, "FETCHES"
, "EXECUTIONS"
, "END_OF_FETCH_COUNT"
, "OPTIMIZER_COST"
, "OPTIMIZER_ENV"
, "COMMAND_TYPE"
, "CON_ID"
FROM CONTAINERS("SYS"."DBA_SQLTUNE_STATISTICS")