SELECT OWNER, SUM(bytes)/1024/1024/1024 AS SIZE_GIG FROM DBA_SEGMENTS GROUP BY OWNER ORDER BY SIZE_GIG ;
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.
Show Conversion Code Hide Conversion Code Show Emoticon Hide Emoticon