Home » RDBMS Server » Server Administration » Database users size (Oracle 8.1.7.4.0,SunOS)
Database users size [message #547985] Mon, 19 March 2012 07:18 Go to next message
Jack14
Messages: 497
Registered: December 2011
Location: INDIA
Senior Member
Hi,

 select  username,account_status,default_tablespace from dba_users;


The ran the above query and it return 80 users but when i ran below query it shows just 14 rows.

select owner,sum(bytes)/(1024*1024) "GB" from dba_segments group by owner;


Can you explain how it is possible? also how to get the size of all 80 users from database ?

Thank you
Re: Database users size [message #547986 is a reply to message #547985] Mon, 19 March 2012 07:31 Go to previous messageGo to next message
Michel Cadot
Messages: 68625
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Some users are not owners.

Regards
Michel
Re: Database users size [message #548237 is a reply to message #547986] Wed, 21 March 2012 00:25 Go to previous message
Jack14
Messages: 497
Registered: December 2011
Location: INDIA
Senior Member

Thank you Michel Smile
Previous Topic: Data Refresh between 8i and 11g
Next Topic: CREATE TABLESPACE AND ORA-03214
Goto Forum:
  


Current Time: Thu Mar 28 13:20:35 CDT 2024