SQL> create table a (b number, c varchar2(30));
表已创建。
SQL> insert into a values (2,'allo');
已创建 1 行。
SQL> select * from v$rollname;
USN NAME
---------- ------------------------------
0 SYSTEM
12 _SYSSMU12$
13 _SYSSMU13$
14 _SYSSMU14$
15 _SYSSMU15$
16 _SYSSMU16$
17 _SYSSMU17$
18 _SYSSMU18$
19 _SYSSMU19$
20 _SYSSMU20$
21 _SYSSMU21$
已选择11行。
SQL> select a.usn,a.xacts,b.name from v$rollstat a,v$rollname b
2 where a.usn=b.usn and a.xacts>0;
USN XACTS NAME
---------- ---------- ------------------------------
18 1 _SYSSMU18$
SQL> select xidusn,xidslot,xidsqn,ubablk,ubafil,ubarec from v$transaction;
XIDUSN XIDSLOT XIDSQN UBABLK UBAFIL UBAREC
---------- ---------- ---------- ---------- ---------- ----------
18 44 697 20 6 15
SQL>
SQL> select usn,writes,rssize,xacts,hwmsize,shrinks,wraps from v$rollstat;
USN WRITES RSSIZE XACTS HWMSIZE SHRINKS WRAPS
---------- ---------- ---------- ---------- ---------- ---------- ----------
0 5072 385024 0 385024 0 0
12 193633432 188416 0 385024 732 3271
13 194831870 253952 0 319488 753 3282
14 196592078 188416 0 385024 720 3318
15 198395506 253952 0 385024 801 3335
16 197977706 188416 0 385024 779 3337
17 197807234 122880 0 385024 696 3333
18 195929804 319488 1 385024 718 3332
19 196886312 122880 0 385024 712 3325
20 193481896 122880 0 319488 770 3263
21 197099192 188416 0 385024 765 3298
已选择11行。
DUMP TRACE:
0x2a 9 0x00 0x02b9 0x002b 0x0000.002081e9 0x01800014 0x0000.000.00000000 0x00000001 0x00000000 1333783430
0x2b 9 0x00 0x02b9 0xffff 0x0000.0020821e 0x01800014 0x0000.000.00000000 0x00000001 0x00000000 1333783465
0x2c 10 0x80 0x02b9 0x0002 0x0000.00208219 0x01800014 0x0000.000.00000000 0x00000001 0x00000000 0
0x2d 9 0x00 0x02b8 0x002e 0x0000.002078ab 0x018000f5 0x0000.000.00000000 0x00000002 0x00000000 1333780711
0x2e 9 0x00 0x02b8 0x002f 0x0000.002078ba 0x018000f7 0x0000.000.00000000 0x00000003 0x00000000 1333780711
0x2f 9 0x00 0x02b8 0x0000 0x0000.002078ef 0x018000b9 0x0000.000.00000000 0x00000003 0x00000000 1333780711
0x2c(16 enter system)=44,Status 10 represents the active transaction。
---------END----------
来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/13750068/viewspace-720625/,如需转载,请注明出处,否则将追究法律责任。
转载于:http://blog.itpub.net/13750068/viewspace-720625/