Confused with v$session and v$process

From: Chuan Zhang <chuan_at_asiaonline.net>
Date: Thu, 29 Mar 2001 17:46:09 -0800
Message-ID: <F001.002DC8C0.20010329174055@fatcity.com>

Hi, DBAs,
 
 
   I think that I might ask a simple

question but I have been confused sometimes for a long time. Could someone help me to clarify these?
 
  First, is " v$session.paddr=v$process.addr"
the only way to join these two tables"
 
 

Second, I am confused about the Username, Osuser in v$session with the Username in v$process.
 

"select a<FONT color=#0000f0

size=2>.program<FONT color=#0000f0 
size=2>, b<FONT color=#0000f0 
size=2>.program<FONT color=#0000f0 
size=2>,a<FONT color=#0000f0 
size=2>.username<FONT color=#0000f0 
size=2>,b<FONT color=#0000f0 
size=2>.username<FONT color=#0000f0 
size=2>,b<FONT color=#0000f0 
size=2>.osuser <FONT color=#0000f0 
size=2>from v$process a<FONT 

color=#0000f0 size=2>, v$session b
where
a.<FONT color=#000000

size=2>addr=<FONT color=#000000 
size=2>b.<FONT color=#000000 
size=2>paddr and<FONT color=#000000 
size=2> sid in<FONT color=#000000 
size=2> (<FONT color=#800000 
size=2>18,<FONT color=#800000 
size=2>33,<FONT color=#800000 
size=2>68,<FONT color=#800000 
size=2>115,<FONT color=#800000 
size=2>144,<FONT color=#800000 
size=2>150)"

One of the results is as follows:<FONT
face="Times New Roman" size=2>

a.program :oracle_at_vantive (TNS V1-V3)
b.username:  iwserver_at_vantive (TNS V1-V3) 
b.username: oracle
a.username: SWBAPPS 
a.username: vantive 

 

Third: I am confused with Spid,pid in v$process and sid in v$session.  Is pid (oracle process id) oracle server process id? what is it used for?
Thanks very much for your help.
Chuan
 
 
 
Received on Thu Mar 29 2001 - 19:46:09 CST