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
Script to get cpu usage and wait event information in oracle database
How to find execution history of an sql_id
Get sid from ospid
How to find cpu and memory information of oracle database server
Find pending distributed pending transactions in oracle
How to monitor parallel queries in oracle db
Find user commits per minute in oracle database
How to get tablespace quota details of an user in oracle
Find the active transactions in oracle database

You May Also Like

Purge AUD$ table using DBMS_AUDIT_MGMT
SAMPLE parameter in EXPDP to export subset of data
Find pending distributed pending transactions in oracle
How to flashback a Pluggable database ( PDB) in oracle 12.2
Flashback primary database in dataguard environment
Defgen utility in Oracle goldengate
Useful ADRCI commands in oracle
Apply database patch from OEM Cloud control
Useful DGMGRL commands in oracle dataguard
ORA-32771: cannot add file to bigfile tablespace

From This Website

MySQL Replication and its Types
How to recreate MGMT database in ORACLE 12C GRID
How to create encrypted tablespace in PDB( oracle 12c)
Deinstall Management Agents Oracle 12c cloud control
How to multiplex control file in standalone database
SGA TARGET ADVISORY IN ORACLE
How to enable flash recovery area in oracle database
REUSE_DUMPFILES parameter in EXPDP
ORA-02304: invalid object identifier literal while import with CREATE TYPE OID
How to use expdp to export data from physical standby database