Home » RDBMS Server » Server Utilities » How to know users?
How to know users? [message #68967] Thu, 04 October 2001 22:22 Go to next message
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.

----------------------------------------------------------------------
Re: How to know users? [message #68970 is a reply to message #68967] Fri, 05 October 2001 05:49 Go to previous messageGo to next message
Rajan A. Vadakepurakal
Messages: 1
Registered: October 2001
Junior Member
select * from dba_users;

----------------------------------------------------------------------
Re: How to know users? [message #68977 is a reply to message #68967] Sat, 06 October 2001 06:27 Go to previous message
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.

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


Current Time: Thu Mar 28 20:40:44 CDT 2024