v$session and v$process -- Simple one

From: Pablo ksksksk <p_rodri99_at_yahoo.es>
Date: Fri, 06 Apr 2001 09:18:15 -0700
Message-ID: <F001.002E423E.20010406084556@fatcity.com>

Hello List,

I've a simple question.
Why do I see this output when I execute the following query:

SQL> l
  1 select a.USERNAME,a.SPID "unix
pid",b.SID,b.serial#,b.osuser,b.program,a.program   2 from v$process a, v$session b
  3 where a.spid='&unixpid'
  4* and a.addr=b.paddr
SQL> USERNAME unix pid SID SERIAL# OSUSER --------------- --------- --------- ---------

PROGRAM PROGRAM

oracle          18463           102      1954 OraUser
C:\ORAWIN\BIN\F45RUN.EXE

oracle_at_fincons (TNS V1-V2)

oracle          18463           142      1263 OraUser
C:\ORAWIN\BIN\F45RUN.EXE

oracle_at_fincons (TNS V1-V2)

Why does it show me 2 oracle SIDs ???

This happens only on some unixpids.

TIA

Do You Yahoo!?
Envía mensajes instantáneos y recibe alertas de correo con Yahoo! Messenger - http://messenger.yahoo.es
--

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

Author: =?iso-8859-1?q?Pablo=20ksksksk?= INET: p_rodri99_at_yahoo.es

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------

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 Fri Apr 06 2001 - 11:18:15 CDT