Oracle 视图 ALL_APPLY_INSTANTIATED_OBJECTS 官方解释，作用，如何使用详细说明
本站中文解释
ALL_APPLY_INSTANTIATED_OBJECTS是Oracle数据库的系统视图，用于描述实施的应用的情况，其中系统支持的所有实施对象是对象，这些对象以实施/存储库对象的形式存在于系统表中，记录实际实施对象的信息，比如包、触发器、过程、函数以及索引。 ALL_APPLY_INSTANTIATED_OBJECTS可以帮助客户查看正在使用的各种实施对象，以便监控实施状态，确定是否有过期或不可用的功能，并根据需要对对象进行更新或更改。
使用ALL_APPLY_INSTANTIATED_OBJECTS视图之前，开发人员需要熟悉系统表中的内容，具体如下：
1.查看实施的所有对象：
SELECT *
FROM ALL_APPLY_INSTANTIATED_OBJECTS
ORDER BY object_name;
2.查看特定应用的实施对象：
SELECT *
FROM ALL_APPLY_INSTANTIATED_OBJECTS
WHERE APPLICATION_NAME = ”
ORDER BY object_name;
3.查看特定应用的对象的状态：
SELECT *
FROM ALL_APPLY_INSTANTIATED_OBJECTS
WHERE APPLICATION_NAME = ”
AND STATUS = ‘VALID’
ORDER BY object_name;
同样，还可以使用其他的筛选条件，如更新时间、对象类型或者数据库版本等来获取特定的实施对象信息。
官方英文解释
ALL_APPLY_INSTANTIATED_OBJECTS displays information about objects accessible to the current user for which an instantiation SCN has been set.
Related View
DBA_APPLY_INSTANTIATED_OBJECTS displays information about objects for which an instantiation SCN has been set.
| Column | Datatype | NULL | Description |
|---|---|---|---|
|
|
|
|
Name of the database where the object originated |
|
|
|
|
Owner of the object at the source database |
|
|
|
|
Name of the object at the source database |
|
|
|
Type of the object at the source database |
|
|
|
|
Instantiation SCN for the object. Only changes committed after this SCN are applied by an apply process. |
|
|
|
|
SCN below which the instantiation SCN cannot be set. This value corresponds to the SCN value at the source database at the time when the object was prepared for instantiation. |
|
|
|
|
Database link to which changes are applied. If null, then changes are applied to the local database. |
|
|
|
|
The global name of the source root database |
See Also:
“DBA_APPLY_INSTANTIATED_OBJECTS”
