1. Database Reference
  2. Static Data Dictionary Views
  3. Static Data Dictionary Views: DBA_HIST_LATCH to DBA_STORED_SETTINGS
  4. DBA_REGISTRY_SQLPATCH

5.284 DBA_REGISTRY_SQLPATCH

DBA_REGISTRY_SQLPATCH contains information about the SQL patches that have been installed in the database.

A SQL patch is a patch that contains SQL scripts which need to be run after OPatch completes. DBA_REGISTRY_SQLPATCH is updated by the datapatch utility. Each row contains information about an installation attempt (apply or roll back) for a given patch.

Column Datatype NULL Description

INSTALL_ID

NUMBER

NOT NULL

Unique numeric identifier for this datapatch session. All patches installed in the same invocation of datapatch will have the same value for INSTALL_ID.

PATCH_ID

NUMBER

NOT NULL

ID associated with the patch

PATCH_UID

NUMBER

NOT NULL

UPI (Universal Patch ID) associated with the patch

PATCH_TYPE

VARCHAR2(10)

NOT NULL

Type of the patch. Possible values:

  • INTERIM: Interim patch

  • RU: Release Update

  • RUI: Release Update Increment

  • RUR: Release Update Revision

  • CU: Cumulative Update

ACTION

VARCHAR2(15)

NOT NULL

APPLY or ROLLBACK

STATUS

VARCHAR2(25)

NOT NULL

Possible values:

  • SUCCESS: Patch application has completed with no errors

  • WITH ERRORS: Patch application finished with errors

ACTION_TIME

TIMESTAMP(6)

NOT NULL

Timestamp when the install was performed

DESCRIPTION

VARCHAR2(100)

Description of this patch from OPatch metadata

LOGFILE

VARCHAR2(500)

NOT NULL

Location of the logfile for this apply or rollback attempt

RU_LOGFILE

VARCHAR2(500)

Logfile location for RU specific commands

FLAGS

VARCHAR2(10)

One or more of the following:

  • U: Patch requires upgrade mode

  • J: Patch is a JVM patch

  • F: Patch was installed using -force

  • B: Patch is a bundle patch

PATCH_DESCRIPTOR

XMLTYPE

Contents of the XML descriptor for the patch

PATCH_DIRECTORY

BLOB

Contents of the patch directory under ORACLE_HOME/sqlpatch

SOURCE_VERSION

VARCHAR2(15)

5 digit version (for example, 18.3.2.0.0) for the version on which the patch was applied

SOURCE_BUILD_DESCRIPTION

VARCHAR2(80)

Build description (for example, Release_Update or Release_Update_Revision) for the version on which the patch was applied

SOURCE_BUILD_TIMESTAMP

TIMESTAMP(6)

Build timestamp for the version on which the patch was applied

TARGET_VERSION

VARCHAR2(15)

5 digit version (for example, 18.4.0.0.0) for the version to be installed

TARGET_BUILD_DESCRIPTION

VARCHAR2(80)

Build description (for example, Release_Update or Release_Update_Revision) for the version to be installed

TARGET_BUILD_TIMESTAMP

TIMESTAMP(6)

Build timestamp for the version to be installed

See Also: