DBA DATABASE SCHEMA SIZE Check

DATABASE SCHEMA SIZE from the database

set linesize 2000
set pagesize 5000
col owner for a155
select OWNER,sum(bytes)/1024/1024/1000 “SIZE_IN_GB” from dba_segments group by owner order by owner;