How to Find Schema Size in Oracle

The Oracle schema owner is the Oracle user who owns all of your database objects.┬áTo check the schema’s size, you will need to obtain all database objects owned or controlled by the user. “Find Schema Size in Oracle“.

Script to Find Schema Size in Oracle

Use the below script to find the schema size.

SQL> SELECT sum(bytes/1024/1024/1024) as "Size in GB" from dba_segments
WHERE owner = 'SCHEMA_NAME'; 

Check all existing schema size

If you want to check all the schema sizes using the below query.

SQL> select owner,sum(bytes/1024/1024/1024) as "Size in GB" from dba_segments group by owner;

Leave a Comment