V$TRANSACTION definition in Oracle Database 11.2
V$TRANSACTION

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')

home |  up