Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: does oracle connection equal one row in v$sessions?
Thank you very much for the corroboration.
Joe
Billy Verreynne wrote:
> Joseph Weinstein <bigdog_at_bea.com> wrote in
>
> > He claims that in spite of our debug code which shows whenever
> > we open an close a connection, (we usually have 20 or so open
> > at any time), they see the V$Sessions having more
> > entries than our application claims to have open....
>
> And he is likely speaking the truth Joe - from first hand experience.
>
> I have seen numerous times that an explicit close JDBC connection in
> JSP does *NOT* close the session on the Oracle side (see my other
> posting under this thread).
>
> The sessions are only closed when the Java servlet engine is bounced
> (which is of course done by restarting Apache).
>
> --
> Billy
Received on Sun Oct 19 2003 - 18:18:12 CDT