Finding schema size in Oracle using SQLPlus CLI

To find out the schema size for a particular user, login as the user into the schema using SQLPlus CLI:

sqlplus schemauser/password

Once logged in, execute the below query:

SELECT sum(bytes)/1024/1024 FROM user_segments;

As per the calculation above (1024/1024), the output will be in MB.

Sample output shown below:

SUM(BYTES)/1024/1024

-------------------

12.4375