1、表结构
SQL> desc v$transaction;
@oI0C.dU7[4I0 名称 是否为空? 类型ITPUB个人空间-G)TE/B�j
mQP^
Ha
----------------------------------------- -------- ----------------------------ITPUB个人空间Xr
P�@N.I:S'B
ADDR RAW(8)
*~9~vy9h
bU W-gw0 XIDUSN NUMBER
b4D
_l t#G0 XIDSLOT NUMBER
w
goa[+`'w!J+N0 XIDSQN NUMBERITPUB个人空间S o;e!b%m8[U0P
UBAFIL NUMBER
7q V;V#` ~&R4[*Xmb[0 UBABLK NUMBER
Uq6U$K4[@0 UBASQN NUMBER
.DvR
Um3d }Yt#rn0 UBAREC NUMBERITPUB个人空间*Q^b:?.sw-l
STATUS VARCHAR2(16)ITPUB个人空间'Q{
V{
];W
START_TIME VARCHAR2(20)ITPUB个人空间.o)uBF&}? M
START_SCNB NUMBER
H Qt@ sd0 START_SCNW NUMBERITPUB个人空间qD4wr+QH%ITc
START_UEXT NUMBERITPUB个人空间|Q6Fu3A
e^.iCu9sic
START_UBAFIL NUMBERITPUB个人空间K[U7zbSz
START_UBABLK NUMBERITPUB个人空间a@
e[e%v
X:u5I;m;E
START_UBASQN NUMBERITPUB个人空间7[e
sS@T [,mWk
START_UBAREC NUMBERITPUB个人空间M"dJ~-OSd9N
SES_ADDR RAW(8)ITPUB个人空间$U8I.WI[-D�s.?A$b
FLAG NUMBER
z;l|`~1F0 SPACE VARCHAR2(3)
+O2^'I+iwgP)E0 RECURSIVE VARCHAR2(3)
FvG8a8x$uK&p0 NOUNDO VARCHAR2(3)ITPUB个人空间XV7]5E`-v
PTX VARCHAR2(3)
E{`3Y
o`)YA0 NAME VARCHAR2(256)
7v!@yK1c0 PRV_XIDUSN NUMBERITPUB个人空间P H
Ap P
PRV_XIDSLT NUMBER
Qh,]%H dE)e0 PRV_XIDSQN NUMBERITPUB个人空间(_oON$S%j
PTX_XIDUSN NUMBERITPUB个人空间?B%Gy
R2
PTX_XIDSLT NUMBER
xGV.iL6vx0 PTX_XIDSQN NUMBERITPUB个人空间 uL Q]#@+3%Rk
DSCN-B NUMBERITPUB个人空间8wfJ+co[
|]1z7P,^&{
DSCN-W NUMBERITPUB个人空间V3E/J2t9NmXBw
USED_UBLK NUMBER
3Dv.{k.iZT0 USED_UREC NUMBERITPUB个人空间1e'g.@V(z"Rhw
LOG_IO NUMBER
N[$~z'N]0 PHY_IO NUMBERITPUB个人空间&R
@0yv#?!C-`
CR_GET NUMBER
M` ?-c?(N+_0 CR_CHANGE NUMBER
~u
u!fj{c-A
O0 START_DATE DATE
n#G7Vrf^bQu0 DSCN_BASE NUMBER
`0h�jE(r+uKd0 DSCN_WRAP NUMBER
$@ZO:M�~-~1i[0 START_SCN NUMBER
-p:@3_V8N:Sk0 DEPENDENT_SCN NUMBER
0{fR?9szV0 XID RAW(8)ITPUB个人空间umEmGd
PRV_XID RAW(8)ITPUB个人空间Y%n%SJ5qFlTQ&o
PTX_XID RAW(8)
HuDS(tv
^$S0
Vca:x4b@6Or7R0 2、根据session id可以查到当前session正在执行的事务信息
v8~�uc+l-Fc:RX7C0 select * from v$transaction where addr in (select taddr from v$session where sid=&sid );ITPUB个人空间I$d6C9~@)S f@4C6Q
H9p'e(R:v5rq dX0
/J'mI0Sw1mT
?0 看下面这两个字段可以看到事务进行到什么程度了:
/Z(p$[md�]o(`w0USED_UBLK
ZM^ANs0NUMBER
-tzh3Xu`+l`&k0Number of undo blocks used
USED_UREC
.FF jbsl$`5p0NUMBER
KeWd;Y+Ep0Number of undo records usedITPUB个人空间,U/xO}+c$nr}
重复查询这两个值,可以看到变化,可以估计事务的进度,尤其是长时间的回滚操作,当这两个值为0,回滚也就完成了。
如
SQL语句如下:
ITPUB个人空间eg UXO
?�tiselect a.sid,
Pd9s$u%B0 a.serial#,
ITPUB个人空间$YIw-u0D6RF*Z a.user#,
vPU+hi*s
w0 a.username,
A%b~�y3(UL0 b.addr,
ITPUB个人空间)}r4OA;S9cu:Kzv3|0q8c b.USED_UBLK,
tF qQ�R$W0 b.USED_UREC
5Qm*[FCzib0 from v$transaction b, v$session a
ITPUB个人空间iAg]{
dR:`h
d4m where b.addr in (select a.taddr from v$session a where a.sid = &sid)
http://space.itpub.net/?uid-9664900-action-viewspace-itemid-676767
添加新评论0 条评论