Find Schema Size in Oracle

How to Find Schema Size in Oracle

by

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';
How to save SQL query output in excel format?

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