does oracle connection equal one row in v$sessions?

From: Joseph Weinstein (bigdog_at_bea.com)
Date: 10/16/03 

Date: Thu, 16 Oct 2003 10:36:56 -0700

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

Relevant Pages

  • Re: Effect of listener on existing connections?
    ... Oracle support is not giving us satisfactory results. ... and attempts to create new connections are ... We also see these messages appearing with regularity in our listener ... how does a blocked listener explain the fact that apps with existing ...
    (comp.databases.oracle.server)
  • Re: Multiple Oracle clients in same code - no usernames needed
    ... You might get away with this with an 9 client and if memory serves me ... In all cases the connections have to 'external' - No name or password ... The mechanism changed to the Oracle wallet in 10 for external ... the 2 oracle client libs will export a lot of the same ...
    (perl.dbi.users)
  • Re: Multiple Oracle clients in same code - no usernames needed
    ... You might get away with this with an 9 client and if memory serves me correctly it can connect both wallet and the old 8 way ... In all cases the connections have to 'external' - No name or password ... The mechanism changed to the Oracle wallet in 10 for external ... the 2 oracle client libs will export a lot of the same ...
    (perl.dbi.users)
  • Re: Effect of listener on existing connections?
    ... Solaris 10 inside a ZFS zone (our previous system was Oracle ... and attempts to create new connections are ... issue of the listener locking up if you're not using ONS. ... how does a blocked listener explain the fact that apps with existing ...
    (comp.databases.oracle.server)
  • Connection delays causing problems.
    ... ORACLE connections sometimes take tens of seconds to come ... This is true whether the connection is via sqlplus, ACCELL ... Over 150 clients running ACCELL applications. ...
    (comp.databases.oracle.server)