dist_query
set markup html onspool 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.
页:
[1]