Find hung transactions in Database during two phase commit
Database: Oracle
Version: 11g
When using two phase commit involved in an application feature, to find out the hung transactions in Oracle database following query can be used:
select * from dba_2pc_pending;
This should display the list of hung transactions with all the particular details including the calling client/user and other details.
Database: Oracle
Version: 11g
When using two phase commit involved in an application feature, to find out the hung transactions in Oracle database following query can be used:
select * from dba_2pc_pending;
This should display the list of hung transactions with all the particular details including the calling client/user and other details.
No comments:
Post a Comment