Oracle 视图 ALL_XSTREAM_OUTBOUND_PROGRESS 官方解释,作用,如何使用详细说明
本站中文解释
Oracle视图ALL_XSTREAM_OUTBOUND_PROGRESS是一种特殊的视图,它提供有关特定XStream Outbound应用程序的进度信息。它可以用来监控XStream Outbound应用的应用程序状态,以便更有效地处理数据。它可以查询有关当前XStream Outbound进程的信息,包括此进程的时间、传输会话ID、目标端点名称和记录ID,以便更好地了解当前XStream Outbound进程的运行情况。
要使用ALL_XSTREAM_OUTBOUND_PROGRESS视图,用户首先需要访问Oracle数据库,并使用正确的权限(如dba或sysdba)授予相应用户查询愿View的权限。授权后,可以使用SELECT语句查询ALL_XSTREAM_OUTBOUND_PROGRESS视图,以获取XStream Outbound应用程序的进度信息。也可以使用其他查询语句,如JOIN,WHERE等,对视图中的内容进行更复杂的筛选和分析。
官方英文解释
ALL_XSTREAM_OUTBOUND_PROGRESS
displays information about the progress made by the XStream outbound servers accessible to the current user.
Related View
DBA_XSTREAM_OUTBOUND_PROGRESS
displays information about the progress made by all XStream outbound servers in the database.
Column | Datatype | NULL | Description |
---|---|---|---|
|
|
|
Name of the outbound server |
|
|
Global name of the database where the transaction originated. For a PDB, this is the global name of the PDB. |
|
|
|
Position of the low-watermark transaction processed by the outbound server |
|
|
|
Time when the processed low position was last updated by the outbound server |
|
|
|
The position of the earliest LCR that is required by the XStream client application |
|
|
|
The global name of the source root database |
|
|
|
|
SCN of the processed low transaction |
|
|
|
Oldest SCN of the transactions currently being captured |
See Also:
“DBA_XSTREAM_OUTBOUND_PROGRESS”