RSA Scripts

Size of schema

Get size of schema in GB.

  1. Oracle
  2. Schema
  3. Intermediate
  4. Vaknin Sammy

Last updated:

Warning: Review and test in a non-production environment before running.

Back to results

SELECT SUM(BYTES)/1024/1024/1024
  FROM DBA_SEGMENTS
 WHERE OWNER = 'APP_SCHEMA';
 
SELECT A.SEGMENT_NAME,A.BYTES/1024/1024/1024 GB
  FROM DBA_SEGMENTS A
 WHERE A.OWNER = 'APP_SCHEMA'
 ORDER BY 2 DESC;