Space taken by a schema in Oracle database

Author:

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’

Leave a Reply

Your email address will not be published.