Oracle 视图 ALL_APPLY_INSTANTIATED_GLOBAL 官方解释,作用,如何使用详细说明
本站中文解释
_UNDOLOG
这个视图ALL_APPLY_INSTANTIATED_GLOBAL_UNDOLOG用于显示当前用户拥有的全局更新及全局撤销日志段的详细信息。
* 视图显示的信息
该视图显示了实例化全局更新及全局撤销日志段的相关信息,包括 PDB 名称,挂载状态,更新日志组段的空间分配,未更新的日志数量等等。
* 用途
该视图可以方便地查看每个用户当前正在使用的全局更新及全局撤销日志段的详细信息,可以查看未更新的日志数量,也可以使用该视图来检查PDB的挂载状态等信息。
官方英文解释
ALL_APPLY_INSTANTIATED_GLOBAL
displays information for the current user about databases for which an instantiation SCN has been set.
Related View
DBA_APPLY_INSTANTIATED_GLOBAL
displays information about databases for which an instantiation SCN has been set.
Column | Datatype | NULL | Description |
---|---|---|---|
|
|
|
Name of the database that was instantiated |
|
|
Instantiation SCN for the database. Only changes committed after this SCN are applied by an apply process. |
|
|
|
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_GLOBAL”