This means the transaction issued by the session is
still rolling back. The session is not killed completely or the table locks
removed till the transaction completely rolls back.
So how do you know when it's going to be over? Just
issue the following query
SELECT USED_UBLK
FROM V$TRANSACTION
WHERE ADDR = (SELECT TADDR FROM V$SESSION WHERE SID
= yoursid)
The USED_BLK shows number of blocks used by this
transaction in the UNDO segments and when this transaction rolls back, the
blocks are released. Issue this query repeatedly and you sould see the
USED_UBLK figure dropping and that will give you some indication how fast the
roll back is taking place.
HTH
Arup Nanda
www.proligence.com
|
- Killed status shuan.tay\(PCI鄭祺勛\)
- Re: Killed status chao_ping
- Re: Killed status Arup Nanda
- Re: Killed status shuan.tay\(PCI鄭祺勛\)
- Re: Killed status Jared Still
- RE: Killed status Richard Ji
- RE: Killed status Ashraf Salaymeh
- Re:Killed status dgoulet
- Re: Re:Killed status shuan.tay\(PCI鄭祺勛\)