ALTER SESSION ADVISE Clause

最新推荐文章于 2025-12-09 09:24:19 发布

转载最新推荐文章于 2025-12-09 09:24:19 发布 · 110 阅读

文章标签：

#数据库

本文详细介绍了如何使用ADVISE子句来处理分布式事务，通过向远程数据库发送建议（如提交(COMMIT)、回滚(ROLLBACK)或不操作(NOTHING)），帮助管理员决定在事务状态不确定时采取何种措施。支持在同一事务中针对不同远程数据库发送不同的建议。

The ADVISE clause sends advice to a remote database to force a distributed
transaction. The advice appears in the ADVICE column of the DBA_2PC_PENDING
view on the remote database (the values are 'C' for COMMIT, 'R' for ROLLBACK, and ' '
for NOTHING). If the transaction becomes in doubt, then the administrator of that
database can use this advice to decide whether to commit or roll back the transaction.
You can send different advice to different remote databases by issuing multiple ALTER
SESSION statements with the ADVISE clause in a single transaction. Each such
statement sends advice to the databases referenced in the following statements in the
transaction until another such statement is issued.[@more@]

来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/10599713/viewspace-1001683/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/10599713/viewspace-1001683/