Oracle教程 2023-02-24

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

Oracle视图DBA_SQL_PATCHES用于查看安装的SQL补丁(如PSU和CPU)以及补丁安装时间。补丁通常用于修正数据库中发现的bug、性能瓶颈和安全漏洞等问题。

它包含以下字段：

Patch_Id：补丁的唯一标识号。
Bug_Number：所覆盖的Bug编号。
Release_Id：补丁发行的版本号。
Description：补丁的简要描述。
Platform：补丁的支持的操作系统。

使用方法：

SELECT *
FROM DBA_SQL_PATCHES;

此语句将显示数据库已经安装的所有SQL补丁的信息。

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

分享到：