Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: monitoring uncommited transactions?
v$transaction will solve yer prob.
Following example explains the scenario
SQL> select * from v$transaction;
no rows selected
SQL> insert into one values(1,sysdate);
1 row created.
SQL> select * from v$transaction;
ADDR XIDUSN XIDSLOT XIDSQN UBAFIL UBABLK
---- ---------- ---------------- -------------------- 02E832D4 2 11 623 2 14449
SQL> commit;
Commit complete.
SQL> select * from v$transaction;
no rows selected
Sent via Deja.com http://www.deja.com/
Before you buy.
Received on Tue Dec 05 2000 - 07:35:26 CST