How to see all sql-statements for a transaction?
Hi,
how can I see what statements belongs to a transaction?
For example:
As user TEST:
set transaction read write name 'my_transaction';
insert into test1 values ('row 1');
insert into test2 values ('row 2');
From another session as user SYSTEM:
select * from v$transaction; ADDR XIDUSN XIDSLOT XIDSQN UBAFIL UBABLK ---------------- ---------- ---------- ---------- ---------- ---------- UBASQN UBAREC STATUS START_TIME START_SCNB ---------- ---------- ---------------- -------------------- ---------- START_SCNW START_UEXT START_UBAFIL START_UBABLK START_UBASQN START_UBAREC ---------- ---------- ------------ ------------ ------------ ------------ SES_ADDR FLAG SPACE RECURSIVE NOUNDO PTX ---------------- ---------- ----- --------- ------ --- NAME -------------------------------------------------------------------------------- PRV_XIDUSN PRV_XIDSLT PRV_XIDSQN PTX_XIDUSN PTX_XIDSLT PTX_XIDSQN DSCN-B ---------- ---------- ---------- ---------- ---------- ---------- ---------- DSCN-W USED_UBLK USED_UREC LOG_IO PHY_IO CR_GET CR_CHANGE ---------- ---------- ---------- ---------- ---------- ---------- ---------- START_DATE DSCN_BASE DSCN_WRAP START_SCN DEPENDENT_SCN XID ---------- ---------- ---------- ---------- ------------- ---------------- PRV_XID PTX_XID ---------------- ---------------- 000007FF62F20218 6 31 1372 3 1845 373 33 ACTIVE 03/04/15 09:35:24 2131131 0 2 3 1845 373 32 000007FF657B9008
0