topic Re: How to know How many users are working on the system? in Operating System - HP-UX

How to know How many users are working on the system?

rveri — Tue, 22 Feb 2005 17:20:20 GMT

I'm hoping someone can tell me , how to know that How many active users are working on the system [ non unix users I mean like oracle , SAP etc users].

I wanted to know , how a system administrator can comes to know how many oracle or SAP or users are logged and working/using the system.

Is there any way to find out that.

Thanks in Advance.

RVeri.
-------

Re: How to know How many users are working on the system?

TwoProc — Tue, 22 Feb 2005 17:27:12 GMT

If your users are direct Oracle connections (no middle tiers in between) - you can just start by examining everything in v$session.
You should be able to make criteria based on machine locations - users names, etc. from
"select * from v$session" pretty easily. If however, you've got a middle tier which is going to "re-handle" the logins for you - well it would be best to visit the SAP support site for the query to give that answer. You should probably do both as a matter of course anyways.

Re: How to know How many users are working on the system?

Uday_S_Ankolekar — Tue, 22 Feb 2005 17:41:09 GMT

use who for unix logins...who -HT will give you idle time also.

-USA..

Re: How to know How many users are working on the system?

Robert Bennett_3 — Tue, 22 Feb 2005 17:45:45 GMT

who | wc -l

Re: How to know How many users are working on the system?

Michael Palmgren — Thu, 24 Feb 2005 09:05:28 GMT

Hi!

Try this
last | grep still | wc -l

/Michael

Re: How to know How many users are working on the system?

Thierry Poels_1 — Thu, 24 Feb 2005 09:17:15 GMT

uptime
;-)

regards,
Thierry.

Re: How to know How many users are working on the system?

Peter Godron — Thu, 24 Feb 2005 09:34:22 GMT

Hi,
the command
ps -ef |awk -F' ' '{print $1}' | grep -v UID | sort -u
will list all the userids of processes running.
If you want to know how many oracle owned processes are running for example:
ps -ef | grep oracle | grep -v grep | wc -l

Regards

Re: How to know How many users are working on the system?

TwoProc — Thu, 24 Feb 2005 10:50:06 GMT

Rveri, One thing to keep in mind is that you *don't* want Oracle Systems processes included in what you're looking for ...

select *
FROM v$session s
WHERE (s.username IS NOT NULL)
AND (NVL (s.osuser, 'x') <> 'SYSTEM')
AND (s.TYPE <> 'BACKGROUND');

Then you can work from the resulting set of data - watching in particular the columns for
username, osuser, machine, module, program, process, action ...

Re: How to know How many users are working on the system?

baiju_3 — Thu, 24 Feb 2005 12:41:37 GMT

Hi Rveri,

netstat -a |grep -i established

Will give you number of established sessions.

Thanks,
BL