Below script will display information about the distributed pending transactions in oracle.

COL local_tran_id FORMAT a13
COL in_out FORMAT a6
COL database FORMAT a25
COL dbuser_owner FORMAT a15
COL interface FORMAT a3
SELECT local_tran_id, in_out, database, dbuser_owner, interface
FROM dba_2pc_neighbors
/
DATABASE SCRIPTS


Related Topics

Find sessions consuming lot of CPU
How to find cpu and memory information of oracle database server
Script to get cpu usage and wait event information in oracle database
Find user commits per minute in oracle database
How to find execution history of an sql_id
Get sid from ospid
Find the active transactions in oracle database
How to get tablespace quota details of an user in oracle
Find pending distributed pending transactions in oracle
How to monitor parallel queries in oracle db

You May Also Like

Oracle database Security Assessment Tool
SETUP ORACLE 18C DATABASE - STEP BY STEP
How to run expdp in pluggable database(PDB)
ORA-32773: operation not supported for smallfile tablespace
How to install OPatch in ORACLE RAC
How to find cpu and memory information of oracle database server
How to find weblogic version in oracle weblogic 12
How to monitor parallel queries in oracle db
How to change sysman password for oracle 12c cloud control
Exception in thread -main" java.lang.OutOfMemoryError: GC overhead limit exceeded with bsu.sh

From This Website

How to move controlfile to a new location in oracle
ORA-01536: space quota exceeded for tablespace
ERROR: permission denied for schema in postgres
sec_case_sensitive_logon parameter in oracle
Add database as target oracle 12c cloud control
How to monitor parallel queries in oracle db
ENABLE_DDL_LOGGING in oracle 12c
How to find cpu and memory information of oracle database server
oraversion utility in oracle 18c - New feature
How to enable flash recovery area in oracle database