Re: does oracle connection equal one row in v$sessions?

Burt Peltier wrote:

> Are you counting background processes (DBWR) and parallel processing (Pnnn)
> spawned sessions? These are in the V$SESSIONS view but could throw off any
> attempt to equate sessions to rows.

Thanks for asking. No, let's assume the customer does differentiate. 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.... Joe

>
>
> --
> "Joseph Weinstein" <bigdog_at_bea.com> wrote in message
> news:3F8ED738.9F448F43_at_bea.com...
> >
> > Hi. I am remotely debugging a multi-user (JDBC) application, connecting
> > via the thin driver to Oracle. The customer is assuming that there is a
> > one-to-one relationship between connections to the DBMS and rows in
> > the V$SESSIONS, yet the applicaiton seems to think there are fewer
> > connections than the rows in V$SESSIONS. Who is right here?
> > thanks
> > Joe
> >
Received on Sat Oct 18 2003 - 13:05:24 CDT