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

Report message to a moderator

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: 68737
Registered: March 2007
Location: Saint-Maur, France, https...
Senior Member
Account Moderator
Some users are not owners.

Regards
Michel

Report message to a moderator

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

Report message to a moderator

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

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Sun Feb 23 07:02:28 CST 2025
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.