Re: Orphaned sessions

I am not a unix guy - btu i know from a friend of mine who is DBA on SUN that there is a confirmed bug in SOLRAIS 2.5 that prevents Oracle from cleaning up the session. Even though there are ways to clean up using the well hidden and non documented X$ Tables (see sys.V_$fixed_table for a list of) but be aware those X$ tables are direct way to the in mem structures of your oracle instance !. On Thu, 28 Aug 1997 17:57:33 -0700, Shelley Alonso <shelley_at_fcicom.com> wrote:

>We are having a problem with orphaned oracle sessions:
>ORACLE 7.3.2.3
>
>we have a Java app running in a Sun Solaris environment connecting to
>Oracle using JDBC. The unix process is routinely being removed with a
>KILL command. Oracle doesn't seem to be cleaning up the Oracle session.
>If you run the following select you will see a transaction in one of the
>rollback segments. Enterprise shows the session with that sid to be
>inactive. There is no text in sqltext area for the session. And it
>doesn't show up as a blocker, yet it seems to be blocking some processes
>from deleting. When we disconnect the session with Enterprise manager,
>the process being blocked finishes.
>I believe that Oracle should be taking care of cleaning up the Oracle
>session when the client goes away.....has anyone seen this happen in
>7.3?
>Thanks,
>Shelley
>SELECT r.usn,
> r.name,
> s.osuser,
> s.username,
> s.sid,
> x.extents,
> x.extends,
> x.waits,
> x.shrinks,
> x.wraps
> FROM sys.v_$rollstat x,
> sys.v_$rollname r,
> sys.v_$session s,
> sys.v_$transaction t
>WHERE t.addr = s.taddr (+)
> AND x.usn (+) = r.usn
> AND t.xidusn (+) = r.usn
> ORDER BY r.usn;
>

Christian Kaas
Client/Server development and consulting Fax. 49-9129-5518
Phone 49-9129-5508 Received on Mon Sep 01 1997 - 00:00:00 CDT