Home » RDBMS Server » Server Administration » Database users
Database users [message #240018] Wed, 23 May 2007 22:32 Go to next message
rsreddy28
Messages: 295
Registered: May 2007
Senior Member
Hello All,

How can I find " how many users are connected to the database ,which user is connected to which machine and which user is doing what activity at the database level .

Can somebody help me in this plz.


bYe,

Raj

Report message to a moderator

Re: Database users [message #240019 is a reply to message #240018] Wed, 23 May 2007 22:41 Go to previous messageGo to next message
BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal
Senior Member
SQL> DESC V$SESSION
select from V$session those columns that are of interest to you.

Report message to a moderator

Re: Database users [message #240022 is a reply to message #240018] Wed, 23 May 2007 23:33 Go to previous message
Mohammad Taj
Messages: 2412
Registered: September 2006
Location: Dubai, UAE
Senior Member
Hi,

and also you can find and see from OEM ( oracle enterprise manager)

Regards
Taj

Report message to a moderator

Previous Topic: Multiple instance creation
Next Topic: Configuring Sandalone Database
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Fri Sep 20 01:42:18 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.