Script to find schema size in Oracle

SELECT sum(bytes) / 1024 / 1024 / 1024 as "Size in GB"
  FROM dba_segments
 WHERE owner = UPPER('&schema_name');
The output should be something like this
Size in GB
----------
20,4860229


Leave a comment or a question in the comment area bellow if you fell like


Be a sport and

Search

Loading... Please wait

Subscribe to our Newsletter

Be a sport and

x