User`s guide

Troubleshooting

8-10 Oracle Database Installation and Administration Guide

■

V$GLOBAL_TRANSACTION

Note: For detailed information about how to use these tables, refer to

the sections in the Oracle Database Administrator's Guide that discuss

failures during two-phase commit and manually overriding in-doubt

transactions.

For transactions generated by Oracle Database/openUTM applications, the following

colu

mn information applies specifically to the

DBA_2PC_NEIGHBORS

table:

■ The

DBID

column is always

xa_orcl

■ The

DBUSER_OWNER

column is always

db_namexa.oracle.com

Remember that the

db_name

is always specified as

db_name

in the open string. If

you do not specify this field in the open string, then the value of this column is

NULLxa.oracle.com

for transactions that are generated by Oracle Database/openUTM

applications.

For example, you could use the following sa

mple SQL statement to find out more

information about in-doubt transactions that are generated by Oracle

Database/openUTM applications.

SELECT * FROM DBA_2PC_PENDING p, DBA_2PC_NEIGHBORS n

WHERE p.LOCAL_TRAN_ID = n.LOCAL_TRAN_ID AND n.DBID = 'xa_orcl';