dist_query

admin

set markup html on
spool dist_queries.html

show user

select name from v$DATABASE;

select * from v$version;

SELECT * FROM DBA_DB_LINKS;

SELECT * FROM GLOBAL_NAME;

select * from DBA_2PC_PENDING;
select * from DBA_2PC_NEIGHBORS;
select * from sys.pending_trans$;
select * from SYS.PENDING_SESSIONS$;
select * from SYS.PENDING_SUB_SESSIONS$;
select * from V$GLOBAL_TRANSACTION;

SELECT KTUXEUSN, KTUXESLT, KTUXESQN, /* Transaction ID */
          KTUXESTA Status,
          KTUXECFL Flags
   FROM sys.x$ktuxe
   WHERE ktuxesta!='INACTIVE';

spool off
set markup html off.