5.323 DBA_SQL_PLAN_DIRECTIVES

DIRECTIVE_ID

NUMBER

NOT NULL

The identifier of the SQL plan directive

TYPE

VARCHAR2(16)

The type of the SQL plan directive

ENABLED^Foot 1

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^Footref 1

XMLTYPE

Extra information about the SQL plan directive