Oracle Server Manager User's Guide

The Transactions Folder

When you click the Transactions folder tab, the Transactions folder opens and the Transaction object list and menu appear. The Transaction object list contains information about distributed transactions that failed in the PREPARED state. For information about distributed transactions, see the Oracle7 Server Concepts.

The following figure illustrates the Transaction object list.

Figure 5 - 5. Transaction Object List

Transaction Object List

The columns of the Transaction object list are described below:

Local ID Identifier on the local database for the transaction.
Global ID Global identifier for the transaction.
State The state of the transaction: collecting, prepared, committed, heuristic commit, or heuristic abort.
Advice Suggested action: C (Commit), R (Rollback), or null (no advice).
Commit Comment Comment given with the COMMENT clause of the COMMIT WORK command.

Forcing a Commit or Rollback

To commit an in-doubt transaction, select the transaction to be committed from the Transaction object list and choose Force Commit from the Transaction menu.

To roll back an in-doubt transaction, select the transaction to be rolled back from the Transaction object list and choose Force Rollback from the Transaction menu.

Attention: You cannot roll back an in-doubt transaction to a savepoint.

Local ID	Identifier on the local database for the transaction.
Global ID	Global identifier for the transaction.
State	The state of the transaction: collecting, prepared, committed, heuristic commit, or heuristic abort.
Advice	Suggested action: C (Commit), R (Rollback), or null (no advice).
Commit Comment	Comment given with the COMMENT clause of the COMMIT WORK command.