|Oracle® Database Administrator's Guide
11g Release 2 (11.2)
|PDF · Mobi · ePub|
SET TRANSACTION ISOLATION LEVEL SERIALIZABLE NAME 'update inventory checkpoint 0';
This example shows that the user started a new transaction with isolation level equal to
SERIALIZABLE and named it
'update inventory checkpoint 0'.
For distributed transactions, the name is sent to participating sites when a transaction is committed. If a
COMMIT COMMENT exists, it is ignored when a transaction name exists.
The transaction name is displayed in the
NAME column of the
V$TRANSACTION view, and in the
TRAN_COMMENT field of the DBA_2PC_PENDING view when the transaction is committed.