1* select addr,ses_addr,xidusn,xidslot,xidsqn,ubafil,ubablk,status,space,recursive,noundo,ptx,name,log_io,phy_io,cr_get,cr_change,xid from v$transaction
ADDR SES_ADDR XIDUSN XIDSLOT XIDSQN UBAFIL UBABLK STATUS SPA REC NOU PTX NAME LOG_IO PHY_IO CR_GET CR_CHANGE XID
---------------- ---------------- ------ ---------- ---------- ---------- ---------- ---------------- --- --- --- --- ---------- ---------- ---------- ---------- ---------- ----------------
000000006F466808 0000000070F5F130 5 21 310 2 2020 ACTIVE NO NO NO NO 38 0 7 0 0500150036010000
SQL> l
1* select addr,ses_addr,xidusn,xidslot,xidsqn,ubafil,ubablk,status,space,recursive,noundo,ptx,name,log_io,phy_io,cr_get,cr_change,xid from v$transaction
SQL>
00000000703B8658 145 TM 51356 0 row-exclusive none 0
--小结:v$rollname之usn 对应 v$rollstat之usn :v$rollstat.usn=v$rollname.usn
SQL> r
1 select a.name,b.*
2 from v$rollname a,v$rollstat b ---联合v$rollname及v$rollstat以usn为联接列,查出回滚段名字及相关信息(extent个数,得到它的头个数,等待它的头个数,收缩次数,扩展次数,它的状态,写入它的大小:以字节计)
3* where a.usn=b.usn and a.usn=5 ---status值:online,pending offline,offline,full;高水位线大小
NAME USN LATCH EXTENTS RSSIZE WRITES XACTS GETS WAITS OPTSIZE HWMSIZE SHRINKS WRAPS EXTENDS AVESHRINK AVEACTIVE STATUS CUREXT CURBLK
---------- ---------- ---------- ---------- ---------- ---------- ---------- ---------- ---------- ---------- ---------- ---------- ---------- ---------- ---------- ---------- ---------- ------ ----------
_SYSSMU5$ 5 0 8 516096 90438 1 148 0 516096 0 2 0 0 19004 ONLINE 3 3
SQL>
---小结:
v$session之taddr及saddr 对应 v$transaction之addr及ses_addr :v$session.taddr=v$transaction.addr and v$session.saddr=v$transaction.ses_addr
而
v$transaction之xidusn 对应v$rollstat之usn : v$transaction.xidusn=v$rollstat.usn
来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/9240380/viewspace-671014/,如需转载,请注明出处,否则将追究法律责任。
转载于:http://blog.itpub.net/9240380/viewspace-671014/