ALTER SESSION ADVISE Clause

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@]