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.280 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_TYPEFoot 1

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_LOGFILEFoot 1

VARCHAR2(500)

Logfile location for RU specific commands

FLAGS

VARCHAR2(10)

One or more of the following:

  • J: Patch is a JVM patch

  • M: Patch installation was merged with another patch

  • N: Patch requires normal mode

  • R: Patch installation has been retried

  • U: Patch requires upgrade mode

PATCH_DESCRIPTOR

XMLTYPE

Contents of the XML descriptor for the patch

PATCH_DIRECTORY

BLOB

Contents of the patch directory under ORACLE_HOME/sqlpatch

SOURCE_VERSIONFoot 1

VARCHAR2(15)

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

SOURCE_BUILD_DESCRIPTIONFoot 1

VARCHAR2(80)

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

SOURCE_BUILD_TIMESTAMPFoot 1

TIMESTAMP(6)

Build timestamp for the version on which the patch was applied

TARGET_VERSIONFoot 1

VARCHAR2(15)

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

TARGET_BUILD_DESCRIPTIONFoot 1

VARCHAR2(80)

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

TARGET_BUILD_TIMESTAMPFoot 1

TIMESTAMP(6)

Build timestamp for the version to be installed

Footnote 1 This column is available starting with Oracle Database release 18c, version 18.1.

See Also: