| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> Re:v$session and v$process -- Simple one
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_at_TMXDEV2] SQL> /
Enter value for username: RSHAMSUD
SID SERIAL# PID SPID MACHINE PROGRAM ---------- ---------- ---------- --------- -------------
52 15994 39 28472 tmatrix2161 sqlplus_at_tmatrix2161 (TNS V1-V3)
[tmatrix2161:RSHAMSUD_at_TMXDEV2] SQL> show user
USER is "RSHAMSUD"
[tmatrix2161:RSHAMSUD_at_TMXDEV2] SQL> set autotrace on
[tmatrix2161:RSHAMSUD_at_TMXDEV2] SQL> /
Enter value for username: RSHAMSUD
SID SERIAL# PID SPID MACHINE PROGRAM ---------- ---------- ---------- --------- -------------
16 31425 39 28472 tmatrix2161 sqlplus_at_tmatrix2161 (TNS V1-V3)
52 15994 39 28472 tmatrix2161 sqlplus_at_tmatrix2161 (TNS V1-V3)
Thanks
Riyaj "Re-yas" Shamsudeen
Certified Oracle DBA
i2 technologies www.i2.com
dgoulet_at_vicr.
com To: Multiple recipients of list ORACLE-L
<ORACLE-L_at_fatcity.com>
Sent by: cc:
root_at_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?= <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
--------------- --------- --------- ---------
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
-- 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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: Riyaj_Shamsudeen_at_i2.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 Sat Apr 07 2001 - 13:41:06 CDT
 |
 |