Thanks Dick,
may be your right, it could be the same user (same
unix pid) with two sessions.
thanks again
- dgoulet_at_vicr.com escribió: > 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____________________
> Subject: v$session and v$process -- Simple one
> 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).
>
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 Mon Apr 09 2001 - 09:08:20 CDT
