select username, default_tablespace, temporary_tablespace from dba_users where account_status='OPEN';
select tablespace_name, owner, sum(bytes/1024/1024) from dba_segments group by tablespace_name, owner;
select username, default_tablespace, temporary_tablespace from dba_users where account_status='OPEN';
select tablespace_name, owner, sum(bytes/1024/1024) from dba_segments group by tablespace_name, owner;