OraFAQ Forum: Server Administration

Home » RDBMS Server » Server Administration » Database users size (Oracle 8.1.7.4.0,SunOS)

Mon, 19 March 2012 07:18

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

Mon, 19 March 2012 07:31

Michel Cadot
Messages: 68757
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

Some users are not owners.

Regards
Michel

Wed, 21 March 2012 00:25

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: Tue May 06 15:21:28 CDT 2025