select
ADDR, -- ADDR RAW(8)
XIDUSN, -- XIDUSN NUMBER
XIDSLOT, -- XIDSLOT NUMBER
XIDSQN, -- XIDSQN NUMBER
UBAFIL, -- UBAFIL NUMBER
UBABLK, -- UBABLK NUMBER
UBASQN, -- UBASQN NUMBER
UBAREC, -- UBAREC NUMBER
STATUS, -- STATUS VARCHAR2(16)
START_TIME, -- START_TIME VARCHAR2(20)
START_SCNB, -- START_SCNB NUMBER
START_SCNW, -- START_SCNW NUMBER
START_UEXT, -- START_UEXT NUMBER
START_UBAFIL, -- START_UBAFIL NUMBER
START_UBABLK, -- START_UBABLK NUMBER
START_UBASQN, -- START_UBASQN NUMBER
START_UBAREC, -- START_UBAREC NUMBER
SES_ADDR, -- SES_ADDR RAW(8)
FLAG, -- FLAG NUMBER
SPACE, -- SPACE VARCHAR2(3)
RECURSIVE, -- RECURSIVE VARCHAR2(3)
NOUNDO, -- NOUNDO VARCHAR2(3)
PTX, -- PTX VARCHAR2(3)
NAME, -- NAME VARCHAR2(256)
PRV_XIDUSN, -- PRV_XIDUSN NUMBER
PRV_XIDSLT, -- PRV_XIDSLT NUMBER
PRV_XIDSQN, -- PRV_XIDSQN NUMBER
PTX_XIDUSN, -- PTX_XIDUSN NUMBER
PTX_XIDSLT, -- PTX_XIDSLT NUMBER
PTX_XIDSQN, -- PTX_XIDSQN NUMBER
"DSCN-B", -- DSCN-B NUMBER
"DSCN-W", -- DSCN-W NUMBER
USED_UBLK, -- USED_UBLK NUMBER
USED_UREC, -- USED_UREC NUMBER
LOG_IO, -- LOG_IO NUMBER
PHY_IO, -- PHY_IO NUMBER
CR_GET, -- CR_GET NUMBER
CR_CHANGE, -- CR_CHANGE NUMBER
START_DATE, -- START_DATE DATE
DSCN_BASE, -- DSCN_BASE NUMBER
DSCN_WRAP, -- DSCN_WRAP NUMBER
START_SCN, -- START_SCN NUMBER
DEPENDENT_SCN, -- DEPENDENT_SCN NUMBER
XID, -- XID RAW(8)
PRV_XID, -- PRV_XID RAW(8)
PTX_XID -- PTX_XID RAW(8)
from
gv$transaction
where
inst_id = USERENV('Instance')