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@]
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博客 ” ，链接：https://blog.itpub.net/10599713/viewspace-1001683/ ，如需转载，请注明出处，否则将追究法律责任。
上一篇：
NOTE OF ANALYZE
下一篇：
FUNCTION : vsize
请登录后发表评论
登录
全部评论
-
博文量740
-
访问量2002852
最新文章
- 人力&人手&人才&人物
- oracle树中prior的用法
- Using Supplied Packages to Manage Stored Outlines
- $ORACLE_HOMERDBMSADMIN目录下各SQL的含义
- PRODUCT_USER_PROFILE Table
- Backing Up Server Parameter Files with RMAN
- Backing Up Control Files with RMAN
- Backing Up Individual Tablespaces with RMAN
- Making Whole Database Backups with RMAN
- 目睹奥运火炬传递
