Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Killed Session: what happens to Rollback
On 22 Apr 2002, marcel.kraupp_at_gmx.ch wrote:
> 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.
Don't know if this is it, but we just had a company-wide email about a bug in Oracle where, if a session had inserted into global temporary table and subsequently got killed, this session's lock on that table never dies. It isn't a huge deal, because the temp tables are session specific, but the transaction/session is still around, at least AFAIU.
-- Galen deForest Boyer Sweet dreams and flying machines in pieces on the ground.Received on Mon Apr 22 2002 - 20:43:20 CDT