Skip Headers
Oracle® Database Reference
12c Release 1 (12.1)

E17615-23
Go to Documentation Home
Home
Go to Book List
Book List
Go to Table of Contents
Contents
Go to Index
Index
Go to Master Index
Master Index
Go to Feedback page
Contact Us

Go to previous page
Previous
Go to next page
Next
PDF · Mobi · ePub

DBA_SQL_PLAN_DIRECTIVES

DBA_SQL_PLAN_DIRECTIVES displays information about the SQL plan directives in the system.

Column Datatype NULL Description
DIRECTIVE_ID NUMBER NOT NULL The identifier of the SQL plan directive
TYPE VARCHAR2(16)   The type of the SQL plan directive
STATE VARCHAR2(13)   The state of the SQL plan directive
AUTO_DROP VARCHAR2(3)   If YES, the SQL plan directive gets dropped when unused beyond SPD_RETENTION_WEEKS
REASON VARCHAR2(36)   The reason for creating the SQL plan directive
CREATED TIMESTAMP(6)   The creation timestamp of the SQL plan directive
LAST_MODIFIED TIMESTAMP(6)   The timestamp of most recent modification of the SQL plan directive
LAST_USED TIMESTAMP(9)   The timestamp of most recent usage of the SQL plan directive

See Also: