This is more generic than that.
It is possible to start up multiple SIDs from a the same process. The original
question was referring to Forms, which has a separate SID for new window/block, at
least from Forms 4 GUI onwards.
Some third party products also do this, eg some TP monitors.
>>> [EMAIL PROTECTED] 04/08/01 07:45AM >>>
Hi
This is the behavior of autotrace. The session has done 'set autotrace
on' and the autotrace creates a separate session using the same
process.
[tmatrix2161:RSHAMSUD@TMXDEV2] SQL> /
Enter value for username: RSHAMSUD
SID SERIAL# PID SPID MACHINE PROGRAM
---------- ---------- ---------- --------- -------------
------------------------------------------------
52 15994 39 28472 tmatrix2161
sqlplus@tmatrix2161 (TNS V1-V3)
[tmatrix2161:RSHAMSUD@TMXDEV2] SQL> show user
USER is "RSHAMSUD"
[tmatrix2161:RSHAMSUD@TMXDEV2] SQL> set autotrace on
[tmatrix2161:RSHAMSUD@TMXDEV2] SQL> /
Enter value for username: RSHAMSUD
SID SERIAL# PID SPID MACHINE PROGRAM
---------- ---------- ---------- --------- -------------
------------------------------------------------
16 31425 39 28472 tmatrix2161
sqlplus@tmatrix2161 (TNS V1-V3)
52 15994 39 28472 tmatrix2161
sqlplus@tmatrix2161 (TNS V1-V3)
Thanks
Riyaj "Re-yas" Shamsudeen
Certified Oracle DBA
i2 technologies www.i2.com
dgoulet@vicr.
com To: Multiple recipients of list ORACLE-L
<[EMAIL PROTECTED]>
Sent by: cc:
root@fatcity. Subject: Re:v$session and v$process --
Simple one
com
04/06/01
12:35 PM
Please
respond to
ORACLE-L
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).
--
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).
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Binley Lim
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).
