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
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: 25050
Registered: January 2009
Location: SoCal
Senior Member
SQL> DESC V$SESSION
select from V$session those columns that are of interest to you.
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
Previous Topic: Multiple instance creation
Next Topic: Configuring Sandalone Database
Goto Forum:
  


Current Time: Sat Dec 10 18:21:53 CST 2016

Total time taken to generate the page: 0.13914 seconds