Oracle 视图 DBA_REGISTRY 官方解释，作用，如何使用详细说明
本站中文解释
Oracle视图（DBA_REGISTRY）提供表示数据库存储库的安装状态的信息，该存储库为添加使用Oracle的功能依赖。 它包含存储库组件是否正确注册，以及可用和不可用存储库组件的信息。
使用此视图，DBA可以轻松查看和管理数据库存储库组件，以确保数据库正确和正常运行。 可以使用以下查询来检查数据库中哪些组件被注册：
SELECT REGISTRY_TAG, COMPONENT_NAME
FROM dba_registry
WHERE status=’VALID’
ORDER BY registry_tag, component_name;
此外，DBA还可以使用此视图跟踪可用和未安装的存储库组件，例如执行以下查询：
SELECT REGISTRY_TAG,STATUS,COMPONENT_NAME
FROM dba_registry
ORDER BY REGISTRY_TAG, STATUS,COMPONENT_NAME;
官方英文解释
DBA_REGISTRY displays information about all components in the database that are loaded into the component registry.
The component registry tracks components that can be separately loaded into the Oracle Database. When a SQL script loads the PL/SQL packages and other database objects for a component into the database, the script records the component name, status, and version. If scripts are used to upgrade/downgrade the dictionary elements for the component, then those scripts also record status and version information.
Related View
USER_REGISTRY displays information about the components owned by the current user that are loaded into the component registry.
| Column | Datatype | NULL | Description |
|---|---|---|---|
|
|
|
|
Component identifier |
|
|
|
Component name |
|
|
|
|
Component version loaded |
|
|
|
|
Component full version |
|
|
|
|
Component status:
|
|
|
|
|
Time when the component was last modified |
|
|
|
|
|
Component namespace |
|
|
|
|
User that created the component entry |
|
|
|
|
User that contains the objects for the component |
|
|
|
Validation procedure |
|
|
|
|
Indicates whether the component requires a startup after the upgrade ( |
|
|
|
|
Parent component identifier |
|
|
|
|
A list of ancillary schema names associated with the component |
See Also:
“USER_REGISTRY”
