ttXactIdGet

This procedure returns transaction ID information for interpreting lock messages. The two result columns of ttXactIdGet are used in combination to uniquely identify a transaction in a database. The first column represents the connection ID and the second column represents the increasing number of transactions for the same transaction ID. Taken individually, the columns are not interesting. The result should only be used to correlate with other sources of transaction information. The numbers may not follow a strict pattern.

Required Privilege

This procedure requires no privilege.

Related Views

This procedure has this related view.

SYS.V$XACT_ID

Syntax

ttXactIdGet()

Parameters

ttXactIdGet has no parameters.

Result Set

ttXactIdGet returns the result set:

Column	Type	Description
`xactID`	`TT_INTEGER`	Connection ID.
`counter`	`TT_BIGINT`	An increasing number that distinguish successive transactions of the same transaction ID.

Examples

Command> autocommit 0;
Command > call ttXactIdGet();
<2,11>
1 row found.
Command> commit;
Command> call ttXactIdGet();
<3, 12>
1 row found.

Note:

The output correlates to the values printed in lock error messages and ttXactAdmin lock information output.