Oracle教程 2023-04-05

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

Oracle视图DBA_SERVER_REGISTRY提供了一种方便多用户访问服务注册表的灵活机制。它支持将信息放入服务器注册表，并提供给对注册表进行查询和修改的一般数据库用户。如果用户需要此信息，他就可以从这个视图中直接查询它们。

使用DBA_SERVER_REGISTRY这个视图非常容易，只需要使用标准的SQL查询语句即可。例如，可以使用SELECT语句从视图中检索数据：

SELECT server_name, key1, value1
FROM dba_server_registry
WHERE key1 LIKE ‘%keyword%’;

上面这条语句将从视图中检索所有key1列中带有“keyword”字样的记录，并且返回server_name列和 value1 列的数据。这样，用户就可以快速检索有关特定信息的数据。

DBA_SERVER_REGISTRY displays information about all server components in the database that are loaded into the component registry.

Column	Datatype	NULL	Description
`COMP_ID`	`VARCHAR2(30)`	`NOT NULL`	Component identifier
`COMP_NAME`	`VARCHAR2(255)`		Component name
`VERSION`	`VARCHAR2(30)`		Component version loaded
`VERSION_FULL`	`VARCHAR2(30)`		Component full version
`STATUS`	`VARCHAR2(11)`		Component status: `INVALID` `VALID` `LOADING` `LOADED` `UPGRADING` `UPGRADED` `DOWNGRADING` `DOWNGRADED` `REMOVING` `REMOVED`
`MODIFIED`	`VARCHAR2(20)`		Time when the component was last modified
`CONTROL`	`VARCHAR2(128)`	`NOT NULL`	User that created the component entry
`SCHEMA`	`VARCHAR2(128)`	`NOT NULL`	User that contains the objects for the component
`PROCEDURE`	`VARCHAR2(61)`		Validation procedure
`STARTUP`	`VARCHAR2(8)`		Indicates whether the component requires a startup after the upgrade (`REQUIRED`) or not
`PARENT_ID`	`VARCHAR2(30)`		Parent component identifier
`OTHER_SCHEMAS`	`VARCHAR2(4000)`		A list of ancillary schema names associated with the component

分享到：