On Unix I run 'netstat -a', count the number of SQLNet connections per remote host,
then
compare that with the number of connections per username in v$session. With that you
can
kinda deduce what hosts are connected to what username. Maybe there is a better way...
Jesse, Rich wrote:
So,
So, there I am, trying to find out what client a connection to an 8.1.7 DB
on Solaris is coming from. Naturally, I SELECT USERNAME, MACHINE, TERMINAL
FROM V$SESSION; Lo and behold, there is a generic login for the username,
column MACHINE in all rows contains jdbcclient and TERMINAL contains