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

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

You May Also Like

How to keep or delete columns/Variable of a data frame in R
Shell script to monitor asm diskgroup usage
oraversion utility in oracle 18c - New feature
Script to get cpu usage and wait event information in oracle database
How to change sysman password for oracle 12c cloud control
How to setup dataguard broker configuration (DG broker) in 12c
How to find cpu and memory information of oracle database server
ERROR: permission denied for schema in postgres
Apply database proactive bundle patch in RAC using manual process
TRUST_EXISTING_TABLE_PARTITIONS in oracle 12.2 datapump

From This Website

OGG-01028 partial record at sequence extract abended
How to create encrypted tablespace in PDB( oracle 12c)
Oracle database Security Assessment Tool
SET ROWLIMIT in oracle 18C - New feature
LOG_CHECKPOINTS_TO_ALERT parameter in oracle
How to get the execution plan for a SQL between two AWR snapshots
ORA-01536: space quota exceeded for tablespace
COLS & COLSEXCEPT FILTER in goldengate
How to keep or delete columns/Variable of a data frame in R
ENABLE_PARALLEL_DML hint in oracle 12c