OraFAQ Forum: Server Utilities » How to know users?

Home » RDBMS Server » Server Utilities » How to know users?

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

How to know users? [message #68967]

Thu, 04 October 2001 22:22

Anil
Messages: 80
Registered: September 2001

Member

Hi,

How can we know how many users we have on the database and they are working in which tablespace?

Thanks,
Kumar.

----------------------------------------------------------------------

Report message to a moderator

Re: How to know users? [message #68970 is a reply to message #68967]

Fri, 05 October 2001 05:49

Rajan A. Vadakepurakal
Messages: 1
Registered: October 2001

Junior Member

select * from dba_users;

----------------------------------------------------------------------

Report message to a moderator

Re: How to know users? [message #68977 is a reply to message #68967]

Sat, 06 October 2001 06:27

Anil
Messages: 80
Registered: September 2001

Member

Hi Rajan,

Thanx for the info, but at same time if i want to
know the user is using which tablespace how to know that? We can know it from OEM tools, but i wanna know by commands.

Thanx again,
Kumar.

----------------------------------------------------------------------

Report message to a moderator

Previous Topic:	Re: FREE OCP PAPERS
Next Topic:	Re: SQLLoader/SQLPlus -- Error Handling

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Wed Jan 08 18:32:14 CST 2025