Simpler Navigation coming for Servers and Operating Systems
Coming soon: a much simpler Servers and Operating Systems section of the Community. We will combine many of the older boards, and you won't have to click through so many levels to get at the information you need. If you are looking for an older board and do not find it, check the consolidated boards, as the posts are still there.
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