Databases
cancel
Showing results for 
Search instead for 
Did you mean: 

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

SOLVED
Go to solution
Gerry Tully
Frequent Advisor

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

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
Any Ideas?
3 REPLIES
Kofi ARTHIABAH
Honored Contributor

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

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
nothing wrong with me that a few lines of code cannot fix!
Gerry Tully
Frequent Advisor

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

The netstat -a will tell me if someone is on, but since we use DHCP I can't be sure of who.
Any Ideas?
Rita C Workman
Honored Contributor
Solution

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

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