Process question

From: Jay Hostetter <jhostetter_at_decommunications.com>
Date: Tue, 24 Sep 2002 08:28:29 -0800
Message-ID: <F001.004D7EA2.20020924082829@fatcity.com>

Do I have something wrong with this query? I thought that each oracle OS process corresponded to one database connection (unless you are using MTS, which we aren't). This query surprised me. It shows that two different oracle database processes each correspond to 3 database connections. Can someone explain this?

Thanks,
Jay

SQL> run

  1  select vs.username,last_call_et, vp.pid,
  2         vs.sid,
  3         vs.serial#,
  4         vs.osuser,
  5         vs.machine,
  6         vs.process,
  7         vp.spid

8 from v$session vs, v$process vp
9 where vs.paddr = vp.addr
10* and process in ('2949917','2952943')

USERNAME     LAST_CALL_ET        PID   SID    SERIAL# OSUSER       MACHINE                   PROCESS   SPID
------------ ------------ ---------- ----- ---------- ------------ ------------------------- --------- ---------
APPS                13180         15    11        456 applmgr      curly.pcsone.com          2949917   2950637
APPS                13227         15   132        951 applmgr      curly.pcsone.com          2949917   2950637
APPS                13746         15   157        198 applmgr      curly.pcsone.com          2949917   2950637
APPS                12761        136   125        961 applmgr      curly.pcsone.com          2952943   2953312
APPS                12840        136   171          9 applmgr      curly.pcsone.com          2952943   2953312
APPS                12808        136   174         13 applmgr      curly.pcsone.com          2952943   2953312

6 rows selected.

**DISCLAIMER
This e-mail message and any files transmitted with it are intended for the use of the individual or entity to which they are addressed and may contain information that is privileged, proprietary and confidential. If you are not the intended recipient, you may not use, copy or disclose to anyone the message or any information contained in the message. If you have received this communication in error, please notify the sender and delete this e-mail message. The contents do not represent the opinion of D&E except to the extent that it relates to their official business.
--

Please see the official ORACLE-L FAQ: http://www.orafaq.com
--

Author: Jay Hostetter
INET: jhostetter_at_decommunications.com

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services
---------------------------------------------------------------------

To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). Received on Tue Sep 24 2002 - 11:28:29 CDT