OraFAQ Forum: Security » How to find number of users connected to database from operating system level

Home » RDBMS Server » Security » How to find number of users connected to database from operating system level

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

How to find number of users connected to database from operating system level [message #240948]

Mon, 28 May 2007 00:37

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

Report message to a moderator

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

Michel Cadot
Messages: 68770
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

OS?
Oracle version?

Regards
Michel

Report message to a moderator

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

vijaykumarsudi
Messages: 9
Registered: September 2006
Location: hyderabad

Junior Member

Hi
I have oracle 10g version and As 4 as my operating system.

Report message to a moderator

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

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

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

Senior Member

$ ps -ef | grep LOCAL | wc -l

Report message to a moderator

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

Michel Cadot
Messages: 68770
Registered: March 2007
Location: Saint-Maur, France, https...

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

Report message to a moderator

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

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

Senior Member

LOCAL=YES or LOCAL=NO are what I see.
HTH & YMMV

Report message to a moderator

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

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

Report message to a moderator

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

Michel Cadot
Messages: 68770
Registered: March 2007
Location: Saint-Maur, France, https...

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:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Mon Sep 08 10:51:57 CDT 2025