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?= <[EMAIL PROTECTED]>
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@fincons (TNS V1-V2)
oracle 18463 142 1263 OraUser
C:\ORAWIN\BIN\F45RUN.EXE
oracle@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: [EMAIL PROTECTED]
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: [EMAIL PROTECTED] (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: [EMAIL PROTECTED]
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: [EMAIL PROTECTED] (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).