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

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

You May Also Like

TRUST_EXISTING_TABLE_PARTITIONS in oracle 12.2 datapump
Upgrade grid infrastructure to 19C oracle
Flashback primary database in dataguard environment
How to find cpu and memory information of oracle database server
SQLCL UTILITY IN ORACLE
ORA-32774: more than one file was specified for bigfile tablespace
Setting up Table replication in oracle goldengate
LREG Background Process in oracle
How to use expdp to export data from physical standby database
resumable_timeout parameter in oracle database

From This Website

Clone a database using dbca command in oracle 19c -New feature
Blackout targets in OEM 12c cloud control
How to add a tempfile in primary database in dataguard
How to flashback a RAC database
Add database as target oracle 12c cloud control
shell script for file system alert
Apply database patch from OEM Cloud control
MySQL Replication and its Types
ORA-32774: more than one file was specified for bigfile tablespace
ORA-32773: operation not supported for smallfile tablespace