drop table a purge;
drop table b purge;
create table a as select systimestamp tmstmp, t.* from v$transaction t where 1=0;
create table b(n int);
/
declare
   procedure trx as
      pragma autonomous_transaction;
   begin
      insert into b values(2);
      insert into a
      select systimestamp tmstmp, t.* from v$session s, v$transaction t where s.SADDR = t.ses_addr;
      commit;
   end;
      
begin
   insert into b values(1);
   insert into a
      select systimestamp tmstmp, t.* from v$session s, v$transaction t where s.SADDR = t.ses_addr;
   dbms_lock.sleep(1);
   trx;
   dbms_lock.sleep(1);
   insert into a
      select systimestamp tmstmp, t.* from v$session s, v$transaction t where s.SADDR = t.ses_addr;
   commit;
end;
/
select flag,bitand(power(2,12),flag) flag12, a.* from a order by tmstmp;