Home » RDBMS Server » Security » How to find number of users connected to database from operating system level
How to find number of users connected to database from operating system level [message #240948] Mon, 28 May 2007 00:37 Go to next message
vijaykumarsudi
Messages: 9
Registered: September 2006
Location: hyderabad
Junior Member

Hi all,
I need to find the number of users connected to database from the
operating system level.is there any way to find this and also can i find the users connected through network.
Thanks in advance
Vijay
Re: How to find number of users connected to database from operating system level [message #240954 is a reply to message #240948] Mon, 28 May 2007 00:54 Go to previous messageGo to next message
Michel Cadot
Messages: 68625
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
OS?
Oracle version?

Regards
Michel
Re: How to find number of users connected to database from operating system level [message #240966 is a reply to message #240954] Mon, 28 May 2007 01:54 Go to previous messageGo to next message
vijaykumarsudi
Messages: 9
Registered: September 2006
Location: hyderabad
Junior Member

Hi
I have oracle 10g version and As 4 as my operating system.
Re: How to find number of users connected to database from operating system level [message #241161 is a reply to message #240966] Mon, 28 May 2007 09:34 Go to previous messageGo to next message
tahpush
Messages: 961
Registered: August 2006
Location: Stockholm/Sweden
Senior Member

I guess you mean Red Hat Linux AS 4 ?

Start with System and Administrative Commands

Then use the "man" command for deeper knowledge of the diffrent commands.

[Updated on: Mon, 28 May 2007 09:34]

Report message to a moderator

Re: How to find number of users connected to database from operating system level [message #241166 is a reply to message #240948] Mon, 28 May 2007 09:47 Go to previous messageGo to next message
BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal
Senior Member
$ ps -ef | grep LOCAL | wc -l
Re: How to find number of users connected to database from operating system level [message #241169 is a reply to message #241166] Mon, 28 May 2007 10:05 Go to previous messageGo to next message
Michel Cadot
Messages: 68625
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Hmm, it seems to me he wants remote user not local ones.

Maybe
$ ps -ef | grep $ORACLE_SID | grep -v LOCAL | wc -l
but I don't have a Unix box to test it.

Regards
Michel
Re: How to find number of users connected to database from operating system level [message #241173 is a reply to message #240948] Mon, 28 May 2007 10:16 Go to previous messageGo to next message
BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal
Senior Member
LOCAL=YES or LOCAL=NO are what I see.
HTH & YMMV
Re: How to find number of users connected to database from operating system level [message #241174 is a reply to message #241169] Mon, 28 May 2007 10:17 Go to previous messageGo to next message
tahpush
Messages: 961
Registered: August 2006
Location: Stockholm/Sweden
Senior Member

Hmm in that case I would go for
ps -ef|grep $ORACLE_SID|grep -v grep|grep LOCAL=no|wc -l

Re: How to find number of users connected to database from operating system level [message #241176 is a reply to message #241173] Mon, 28 May 2007 10:26 Go to previous message
Michel Cadot
Messages: 68625
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
This is what I said, I don't have a Unix box to see what's there. Smile

Regards
Michel

[Updated on: Mon, 28 May 2007 10:26]

Report message to a moderator

Previous Topic: oracle username & password
Next Topic: LOGON vs. LOGOFF during auditing
Goto Forum:
  


Current Time: Fri Mar 29 10:01:57 CDT 2024