Oracle教程 2023-03-24

Oracle 视图 DBA_REGISTRY_SQLPATCH 官方解释，作用，如何使用详细说明

本站中文解释

Oracle视图DBA_REGISTRY_SQLPATCH可用于汇总Oracle数据库的SQL Patch（补丁）的相关信息。它显示补丁或SQL条件包含的语句及表示补丁状态的列，如果已应用了补丁，它也会显示该补丁的说明。

DBA_REGISTRY_SQLPATCH视图使DBA可以查询已安装的SQL补丁，可让其了解安装后的改变，进而尽可能避免SQL补丁和数据库不兼容的问题，也可以查询指定补丁是否已安装，以及未安装补丁可能导致的问题。

使用这个视图需要系统权限，需要以SYSDBA身份登录并执行以下查询：

SELECT * FROM DB_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: `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_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

本站中文解释

官方英文解释

相关推荐