DIRECTIVE_ID

NUMBER

NOT NULL

The identifier of the SQL plan directive

TYPE

VARCHAR2(16)

The type of the SQL plan directive:

• DYNAMIC SAMPLING: SQL plan directive

• DYNAMIC SAMPLING RESULT: Dynamic sampling query results. This value appears only in Oracle Database 12c Release 2 (12.2.0.1) and later releases.

• UNKNOWN: Unknown

ENABLED

VARCHAR2(3)

Indicates whether the SQL plan directive is enabled. Possible values:

• YES: The SQL plan directive is enabled.

• NO: The SQL plan directive is not enabled.

STATE

VARCHAR2(10)

The state of the SQL plan directive. Possible values include:

• SUPERSEDED: This value indicates that the corresponding column or groups have an extension or histogram, or that another SQL plan directive exists that can be used for the directive.

• USABLE: This value indicates that the SQL plan directive is usable for the optimizer.

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

NOTES

XMLTYPE

Extra information about the SQL plan directive