Oracle 视图 V$XSTREAM_TRANSACTION 官方解释，作用，如何使用详细说明
本站中文解释
Oracle视图V$XSTREAM_TRANSACTION用来查看实时重复的当前活动事务信息。它可以帮你监控事务在重复之间的状态，检测哪些语句在重复中未能得到执行，以及收集每秒数据库、重复及流中已完成事务的信息。
要使��V$XSTREAM_TRANSACTION视图，你可以执行带有SELECT权限的查询语句，它可以列出所有活动的实时重复事务。
例如：SELECT * FROM v$xstream_transaction;
上述查询语句会返回所有活动的实时重复事务，并显示每个事务的详细信息，比如事务状态、开始和结束时间、目标实例等。
官方英文解释
V$XSTREAM_TRANSACTION displays information about transactions that are being processed by capture processes, outbound servers, and inbound servers. This view can identify long running transactions and to display how many LCRs are being processed in each transaction. This view only contains information about captured LCRs. It does not contain information about user-enqueued LCRs or user messages.
This view only shows information about LCRs that are being processed because they satisfied the rule sets for the component at the time of the query. For capture processes, this view only shows information about changes in transactions that the capture process has converted into LCRs. It does not show information about all the active transactions present in the redo log.
For outbound servers, this view only shows information about LCRs that the outbound server has dequeued. It does not show information about LCRs in the outbound server’s queue. For outbound servers, information about a transaction remains in the view until the transaction is sent to the XStream client application.
For inbound servers, information about a transaction remains in the view until the transaction commits or until the entire transaction is rolled back.
| Column | Datatype | Description |
|---|---|---|
|
|
|
Name of the component |
|
|
|
Type of component
|
|
|
|
Transaction ID undo segment number of the transaction |
|
|
|
Transaction ID slot number of the transaction |
|
|
|
Transaction ID sequence number of the transaction |
|
|
|
Number of LCRs processed in the transaction. If a component is restarted while the transaction is being processed, then this column shows the number of LCRs processed in the transaction since the component was started. |
|
|
|
Total number of LCRs processed in the transaction by an outbound server or inbound server. This column does not pertain to capture processes. |
|
|
|
Time stamp of the first LCR processed in the transaction. If a capture process is restarted while the transaction is being processed, then this column shows the time stamp of the first LCR processed after the capture process was started. |
|
|
|
SCN of the first message in the transaction. If a capture process is restarted while the transaction is being processed, then this column shows the SCN of the first message processed after the capture process was started. |
|
|
|
Time stamp of the last LCR processed in the transaction |
|
|
|
SCN of the most recent message encountered for the transaction |
|
|
|
Position of the first message seen by an XStream inbound server This column is populated only for an apply process that is functioning as an XStream inbound server. |
|
|
|
Position of the last message seen by an XStream inbound server. This column is populated only for an apply process that is functioning as an XStream inbound server. |
|
|
|
Transaction ID for an XStream inbound server. This column is populated only for an apply process that is functioning as an XStream inbound server. |
|
|
|
The ID of the container to which the data pertains. Possible values include:
|
