Re: Killed Session: what happens to Rollback

Look in v$transaction for used_urec, used_ublk (undo records and blocks used by the transaction).

In normal circumstances when a process rolls a transaction back, you can see these decreasing and estimate how long it will take for the rollback to complete. If you kill a session, PMON takes control of the locked resources and performs the rollback - unfortunately it doesn't unwind the counts in these columns in the same way as a normal rollback.

--
Jonathan Lewis
http://www.jlcomp.demon.co.uk

Author of:
Practical Oracle 8i: Building Efficient Databases

Next Seminar - Australia - July/August
http://www.jlcomp.demon.co.uk/seminar.html

Host to The Co-Operative Oracle Users' FAQ
http://www.jlcomp.demon.co.uk/faq/ind_faq.html



Marcel Kraupp wrote in message
<332bb004.0204220849.6391ded8_at_posting.google.com>...


>Hi

>

>I have a killed session:

>

>SQL> select sid, taddr from v$session where status = 'KILLED';

>

>       SID TADDR

>---------- --------

>        28 2340BDE4

>

>

>I find taddr referenced in v$transaction:

>

>SQL> select count(*) from v$transaction where addr = '2340BDE4';

>

>  COUNT(*)

>----------

>         1

>

>

>And I am wondering if this entry in v$transaction (as well as its

counterpart


>in v$session) will eventually disappear. And what do I have to do if they

>are not? It seems to me that the instance should take care of, but

>the entries are here for a long time already.

>

>Also, is there a way to determine how much space a transaction has

allocated


>in the rollback segment.

>