Re: MTS oracle 8.1.7

From: srivenu <srivenu_at_hotmail.com>
Date: 16 Sep 2002 22:59:00 -0700
Message-ID: <1a68177.0209162159.4fa4f66d@posting.google.com>

Use v$session_connect_info to get more info about session connectivity

example:

select a.sid,substr(b.username,1,10) username,substr(a.osuser,1,10) osuser,

	 b.server,a.authentication_type Authentication,a.Network_Service_banner network,
	 substr(b.program,1,15) program,substr(b.machine,1,24) machine

from v$session_connect_info a,v$session b where a.sid=b.sid
order by 1

regards
Srivenu Received on Tue Sep 17 2002 - 00:59:00 CDT