Is there an easy way to tell who is logged on?

[Gerry Tully]

We have recently upgraded to the web based Oracle database. Before this I could easily do a 'who' and see who was on the system. Now it's not that easy. Anyone have a quick solution without having to go into oracle to find out? TIA

[Kofi ARTHIABAH]

You could try :

netstat -a | grep ESTABLISHED

you can tell which ip addresses are connected to the server and if you have a map of usernames -> ipaddresses or hostnames that would be it.

Good luck

[Gerry Tully]

The netstat -a will tell me if someone is on, but since we use DHCP I can't be sure of who.

[Rita C Workman · Accepted solution]

Well I don't know if this will do it for you, but I have a 'kindly' DBA who gave this to me to run, whenever I needed to find out....

Maybe, with some modifications, you could use it.

rcw