VIEW: SYS.CDB_SQL_PLAN_BASELINES

Source

View Text - Preformatted

SELECT "SIGNATURE","SQL_HANDLE","SQL_TEXT","PLAN_NAME","CREATOR","ORIGIN","PARSING_SCHEMA_NAME","DESCRIPTION","VERSION","CREATED","LAST_MODIFIED","LAST_EXECUTED","LAST_VERIFIED","ENABLED","ACCEPTED","FIXED","REPRODUCED","AUTOPURGE","ADAPTIVE","OPTIMIZER_COST","MODULE","ACTION","EXECUTIONS","ELAPSED_TIME","CPU_TIME","BUFFER_GETS","DISK_READS","DIRECT_WRITES","ROWS_PROCESSED","FETCHES","END_OF_FETCH_COUNT","CON_ID" FROM CONTAINERS("SYS"."DBA_SQL_PLAN_BASELINES")

View Text - HTML Formatted

SELECT "SIGNATURE"
, "SQL_HANDLE"
, "SQL_TEXT"
, "PLAN_NAME"
, "CREATOR"
, "ORIGIN"
, "PARSING_SCHEMA_NAME"
, "DESCRIPTION"
, "VERSION"
, "CREATED"
, "LAST_MODIFIED"
, "LAST_EXECUTED"
, "LAST_VERIFIED"
, "ENABLED"
, "ACCEPTED"
, "FIXED"
, "REPRODUCED"
, "AUTOPURGE"
, "ADAPTIVE"
, "OPTIMIZER_COST"
, "MODULE"
, "ACTION"
, "EXECUTIONS"
, "ELAPSED_TIME"
, "CPU_TIME"
, "BUFFER_GETS"
, "DISK_READS"
, "DIRECT_WRITES"
, "ROWS_PROCESSED"
, "FETCHES"
, "END_OF_FETCH_COUNT"
, "CON_ID"
FROM CONTAINERS("SYS"."DBA_SQL_PLAN_BASELINES")