Oracle 视图 V$GOLDENGATE_TRANSACTION 官方解释,作用,如何使用详细说明
Oracle视图V$GOLDENGATE_TRANSACTION能够显示实时GoldenGate数据库及传输信息。
此视图能够根据用户指定的属性来显示GoldenGate及其关联的事务。它由GoldenGate进程创建,该进程从正在正在运行中的GoldenGate事务中抓取信息。此视图中还包括事务和传输记录,其在GoldenGate参数文件中被配置。
该视图可以帮助用户了解那些 GoldenGate事务成功处理,哪些传输失败,以及一些如发送/接收时间,传输大小,事务等的附加信息。
使用方法:
1. 打开Oracle数据库客户端,并连接到数据库;
2. 执行SELECT * FROM V$GOLDENGATE_TRANSACTION命令查看详细的Goldengate事务信息。
V$GOLDENGATE_TRANSACTION displays information about transactions that are being processed by Oracle GoldenGate capture processes, outbound servers, and inbound servers.
This view can identify long running transactions and 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 Oracle GoldenGate 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.
PROPAGATION_SENDER Propagation sender that sends LCRs from a capture process to an outbound server
Transaction ID undo segment number of the batch parent transaction.
When using BATCHSQL mode in Oracle GoldenGate Integrated Replicat the BATCH_XID columns identify the parent transaction of the batch the current transaction belongs to. The parent transaction is the first transaction of each batch.
This column is populated only if COMPONENT_TYPE is APPLY and BATCHSQL mode is enabled.
Transaction ID slot number of the batch parent transaction.
When using BATCHSQL mode in Oracle GoldenGate Integrated Replicat the BATCH_XID columns identify the parent transaction of the batch the current transaction belongs to. The parent transaction is the first transaction of each batch.
This column is populated only if COMPONENT_TYPE is APPLY and BATCHSQL mode is enabled.
Transaction ID sequence number of the batch parent transaction.
When using BATCHSQL mode in Oracle GoldenGate Integrated Replicat the BATCH_XID columns identify the parent transaction of the batch the current transaction belongs to. The parent transaction is the first transaction of each batch.
This column is populated only if COMPONENT_TYPE is APPLY and BATCHSQL mode is enabled.
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.
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 Oracle GoldenGate inbound server.
Position of the last message seen by an Oracle GoldenGate inbound server
This column is populated only for an apply process that is functioning as an Oracle GoldenGate inbound server.
Transaction ID for an Oracle GoldenGate inbound server
This column is populated only for an apply process that is functioning as an Oracle GoldenGate inbound server.
0: This value is used for rows containing data that pertain to the entire CDB. This value is also used for rows in non-CDBs.
我想要获取技术服务或软件
服务范围:MySQL、ORACLE、SQLSERVER、MongoDB、PostgreSQL 、程序问题
服务方式:远程服务、电话支持、现场服务,沟通指定方式服务
技术标签:数据恢复、安装配置、数据迁移、集群容灾、异常处理、其它问题
本站部分文章参考或来源于网络,如有侵权请联系站长。
数据库远程运维 Oracle 视图 V$GOLDENGATE_TRANSACTION 官方解释,作用,如何使用详细说明
相关文章
- ORA-22374: cannot reset the version of a type with table dependents ORACLE 报错 故障修复 远程处理
- Oracle 视图 DBA_AUTOTASK_STATUS 官方解释,作用,如何使用详细说明
- Oracle 视图 DBA_TSDP_IMPORT_ERRORS 官方解释,作用,如何使用详细说明
- Oracle 视图 USER_PLSQL_COLL_TYPES 官方解释,作用,如何使用详细说明
- Oracle 视图 USER_XML_SCHEMA_SUBSTGRP_HEAD 官方解释,作用,如何使用详细说明
- Oracle 视图 V$SQL_PLAN_STATISTICS 官方解释,作用,如何使用详细说明
- Oracle 等待事件 undo segment recovery 官方解释,作用,如何使用及优化方法
- Oracle:免费使用的好处(oracle免费吗)
- Oracle补零――解决数据不完整问题(oracle补零)
- 解析深入浅出:Oracle数据库表案例分析(oracle数据库表案例)
- 提升效率: 使用Oracle进行大数据更新(oracle大数据量更新)
- 学会使用Oracle Q操作,实现数据加速处理(oracle q 操作)
- Oracle 时间戳转换完整教程,快乐高效!(oracle时间戳转换)
- ogg实现Oracle数据同步的利器(ogg部署oracle)
- 利用Oracle主备模式实现可靠的数据保护(oracle主备模式)
- 的使用深入了解Oracle语句块的使用方式(oracle中语句块)
- Oracle中使用空格替换实现字符串操作(oracle中的空格替换)
- Oracle中使用正则表达式实现数据库全文检索(oracle中正则查找)
- 如何在Oracle中使用锁技术保护数据(oracle中如何添加锁)
- Oracle中如何复制表头(oracle中复制表头)
- 器Oracle中SQL运行机制取得成功(oracle中sql运行)
- 如何使用Oracle查询PID(oracle pid查看)
- 使用Oracle EM管理档案库,提高效率(oracle em档案库)
- Oracle DBA把IT未来锁定在你的手里(oracle dba 吧)
- Oracle一个月的财务分析报表(oracle一个月的报表)