5.360 DBA_SQL_PATCHES

DBA_SQL_PATCHES displays the set of SQL patches.

Column Datatype NULL Description

NAME

VARCHAR2(128)

NOT NULL

Name of the SQL patch

CATEGORY

VARCHAR2(128)

NOT NULL

Category of the SQL patch

SIGNATURE

NUMBER

NOT NULL

Unique identifier generated from normalized SQL text

SQL_TEXT

CLOB

NOT NULL

Un-normalized SQL text

CREATED

TIMESTAMP(6)

NOT NULL

Timestamp when the SQL patch was created

LAST_MODIFIED

TIMESTAMP(6)

Timestamp when the SQL patch was last modified

DESCRIPTION

VARCHAR2(500)

Text description provided for the SQL patch

STATUS

VARCHAR2(8)

Status of the SQL patch:

  • ENABLED

  • DISABLED

FORCE_MATCHING

VARCHAR2(3)

Indicates whether the signature is force matching (YES) or exact matching (NO)

TASK_ID

NUMBER

Advisor task ID that generated the SQL patch

TASK_EXEC_NAME

VARCHAR2(128)

Advisor execution name for the SQL patch

TASK_OBJ_ID

NUMBER

Advisor object ID for the SQL patch

TASK_FND_ID

NUMBER

Advisor finding ID for the SQL patch

TASK_REC_ID

NUMBER

Advisor recommendation ID for the SQL patch