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

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

Be a sport and


Loading... Please wait

Subscribe to our Newsletter

Be a sport and