SQL Script to show the size of each schema in an Oracle database:

SELECT OWNER,SUM(BYTES/1024/1024) “SIZE OF SCHEMA(MEGABYTES)”
FROM DBA_EXTENTS
GROUP BY OWNER
ORDER BY SUM(BYTES/1024/1024) DESC Check links . web design history