Re:v$session and v$process -- Simple one

From: <dgoulet_at_vicr.com>
Date: Fri, 06 Apr 2001 09:35:19 -0700
Message-ID: <F001.002E43D3.20010406093531@fatcity.com>

Looks to me like you've either got two users connected to the database from Windows or one user with two sessions. And if I'm not totally mistaken I believe that 'OraUser' is a generic entry when the client computer does not have it's computer name set.

Dick Goulet

____________________Reply Separator____________________
Author: =?iso-8859-1?q?Pablo=20ksksksk?= <p_rodri99_at_yahoo.es>
Date:       4/6/2001 8:45 AM

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).

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

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:35:19 CDT