Re: Help on V$ join

From: Charles Dye PC <cdye_at_DNT.DIALOG.COM>
Date: Thu, 11 Jan 1996 12:35:07 -0800
Message-Id: <9601112054.AA26376@alice.jcc.com>

Dave,

v$session.sid = v$process.pid

v$session.paddr = v$process.addr

Regards,
Charles_Dye_at_corp.dialog.com

• Begin Included Message -----

>From owner-oracle-l_at_CCVM.SUNYSB.EDU Thu Jan 11 12:20:28 1996
Date: Thu, 11 Jan 1996 14:18:00 PST From: Tribble Dave <DLT3716_at_KCPL.COM>

Subject:      Help on V$ join
X-To:         oraworld <oracle-l_at_CCVM.SUNYSB.EDU>

To: Multiple recipients of list ORACLE-L <ORACLE-L_at_ccvm.sunysb.edu>

Can someone tell me what column(s) I can use to join the tables: v$session
v$process
???????????
They have like names for columns but I can't find values that seem to jive. ----- End Included Message ----- Received on Thu Jan 11 1996 - 15:54:24 CST