Query to find the size of schema in Oracle Database

The following query will show you howto get the schema size in GB in Oracle Database.

SELECT OWNER, SUM(bytes)/1024/1024/1024 AS SIZE_GIG FROM DBA_SEGMENTS GROUP BY OWNER ORDER BY SIZE_GIG ;
Previous
Next Post »
Thanks for your comment