topic Users accessing a system in Operating System - HP-UX

Users accessing a system

Coolmar — Fri, 28 Oct 2005 11:47:45 GMT

Hi,

How can you tell how many users are accessing the system. I mean the users that access Oracle that wouldn't show up with a "who" or "w" - from an HP view rather than going into Oracle as a dba?

Re: Users accessing a system

Sundar_7 — Fri, 28 Oct 2005 12:25:26 GMT

Oracle creates a process with the name "oracle" for every connection to the instance.

For ex if the SID of your DB is test1 , you can grep for oracletest1. This will give you the count of the oracle connections

LOCAL=NO means the connection is remote. LOCAL=YES means the connection was made from the system.

Re: Users accessing a system

Geoff Wild — Fri, 28 Oct 2005 12:26:23 GMT

Don't know off the top of my head if you can pick up users - but you can see connections from machines with a netstat -a

Rgds...Geoff

Re: Users accessing a system

Granite — Fri, 28 Oct 2005 12:32:29 GMT

Hi Sally,

As pointed by Sundar, you can grep the DB connections like this :

--> No. of connections,
remote, ps -ef|grep -i local=no|wc -l
local, ps -ef|grep -i local=yes|wc -l

regds,Granite

Re: Users accessing a system

Coolmar — Fri, 28 Oct 2005 15:04:32 GMT

Thanks!