VIEW: SYS.CDB_SQLSET_STATEMENTS

Source

View Text - Preformatted

SELECT "SQLSET_NAME","SQLSET_OWNER","SQLSET_ID","CON_DBID","SQL_ID","FORCE_MATCHING_SIGNATURE","SQL_TEXT","PARSING_SCHEMA_NAME","PARSING_SCHEMA_ID","PLAN_HASH_VALUE","BIND_DATA","BINDS_CAPTURED","MODULE","ACTION","ELAPSED_TIME","CPU_TIME","BUFFER_GETS","DISK_READS","DIRECT_WRITES","ROWS_PROCESSED","FETCHES","EXECUTIONS","END_OF_FETCH_COUNT","OPTIMIZER_COST","OPTIMIZER_ENV","PRIORITY","COMMAND_TYPE","FIRST_LOAD_TIME","STAT_PERIOD","ACTIVE_STAT_PERIOD","OTHER","PLAN_TIMESTAMP","SQL_SEQ","CON_ID" FROM CONTAINERS("SYS"."DBA_SQLSET_STATEMENTS")

View Text - HTML Formatted

SELECT "SQLSET_NAME"
, "SQLSET_OWNER"
, "SQLSET_ID"
, "CON_DBID"
, "SQL_ID"
, "FORCE_MATCHING_SIGNATURE"
, "SQL_TEXT"
, "PARSING_SCHEMA_NAME"
, "PARSING_SCHEMA_ID"
, "PLAN_HASH_VALUE"
, "BIND_DATA"
, "BINDS_CAPTURED"
, "MODULE"
, "ACTION"
, "ELAPSED_TIME"
, "CPU_TIME"
, "BUFFER_GETS"
, "DISK_READS"
, "DIRECT_WRITES"
, "ROWS_PROCESSED"
, "FETCHES"
, "EXECUTIONS"
, "END_OF_FETCH_COUNT"
, "OPTIMIZER_COST"
, "OPTIMIZER_ENV"
, "PRIORITY"
, "COMMAND_TYPE"
, "FIRST_LOAD_TIME"
, "STAT_PERIOD"
, "ACTIVE_STAT_PERIOD"
, "OTHER"
, "PLAN_TIMESTAMP"
, "SQL_SEQ"
, "CON_ID"
FROM CONTAINERS("SYS"."DBA_SQLSET_STATEMENTS")