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

From: Turkbear (
Date: 10/16/03

Date: Thu, 16 Oct 2003 14:52:27 -0500

Depending on how the application determines connections, it may not be counting those sessions used by background processes.
  1* select username from v$session
SQL> /






17 sessions, just 9 user sessions...

Joseph Weinstein <> wrote:

>Brian Peasland wrote:
>> Depending on your configuration, you could both be right. Are you using
>> dedicated server connections or Shared Server connections? In dedicated
>> server, there is a one-to-one correspondance. In a Shared Server
>> configuration, there is a many-to-one correspondance. And it is possible
>> to employ a mixture of the two. You'll have to determine your
>> configuration to know.
>> HTH,
>> Brian
>Thanks! For me to be clear, with shared server connections, an application
>that makes and closes JDBC connections, may at some point think it has
>N currently open connections, bu the DBMS V$Session view will show
>more sessions? (N+M)? I would have assumed that shared meant many-to-one
>the other way, such that multiple logically distinct application connections
>might share a single DBMS session...
>> Joseph Weinstein wrote:
>> >
>> > 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
>> --
>> ===================================================================
>> Brian Peasland
>> Remove the "remove_spam." from the email address to email me.
>> "I can give it to you cheap, quick, and good. Now pick two out of
>> the three"