Space taken by a schema in Oracle database
To get the space taken up by all the objects in the schema, the following query can be used select ((sum(bytes)/1024)/1024)/1024 Space_in_GB from dba_segments where owner=’SCHEMA_NAME’
To get the space taken up by all the objects in the schema, the following query can be used select ((sum(bytes)/1024)/1024)/1024 Space_in_GB from dba_segments where owner=’SCHEMA_NAME’