Users accessing a system

[Coolmar]

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?

[Sundar_7 · Accepted solution]

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.

[Geoff Wild]

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

[Granite]

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

[Coolmar]

Thanks!