DBA Data[Home] [Help]

VIEW: SYS.CDB_SQL_PLAN_DIRECTIVES

Source

View Text - Preformatted

SELECT "DIRECTIVE_ID","TYPE","ENABLED","STATE","AUTO_DROP","REASON","CREATED","LAST_MODIFIED","LAST_USED","NOTES","CON_ID" FROM CONTAINERS("SYS"."DBA_SQL_PLAN_DIRECTIVES")
View Text - HTML Formatted

SELECT "DIRECTIVE_ID"
, "TYPE"
, "ENABLED"
, "STATE"
, "AUTO_DROP"
, "REASON"
, "CREATED"
, "LAST_MODIFIED"
, "LAST_USED"
, "NOTES"
, "CON_ID"
FROM CONTAINERS("SYS"."DBA_SQL_PLAN_DIRECTIVES")