SET PAGESIZE 100;
COL owner FORMAT A20;
SELECT owner, SUM(BYTES)/1024/1024/1024 AS "Size in GB"
FROM dba_segments
WHERE owner NOT IN (
'ANONYMOUS','APEX_040200','APEX_PUBLIC_USER','APPQOSSYS','AUDSYS','BI','CTXSYS','DBSNMP','DIP',
'DVF','DVSYS','EXFSYS','FLOWS_FILES','GSMADMIN_INTERNAL','GSMCATUSER','GSMUSER','HR','IX',
'LBACSYS','MDDATA','MDSYS','OE','ORACLE_OCM','ORDDATA','ORDPLUGINS','ORDSYS','OUTLN','PM',
'SCOTT','SH','SI_INFORMTN_SCHEMA','SPATIAL_CSW_ADMIN_USR','SPATIAL_WFS_ADMIN_USR','SYS',
'SYSBACKUP','SYSDG','SYSKM','SYSTEM','WMSYS','XDB','SYSMAN','RMAN','RMAN_BACKUP','OWBSYS',
'OWBSYS_AUDIT','APEX_030200','MGMT_VIEW','OJVMSYS'
)
GROUP BY owner
HAVING SUM(BYTES)/1024/1024/1024 >= '1'
ORDER BY owner ASC;
OWNER Size in GB
-------------------- ----------
USR01 143.701416
USR02 8.28820801
USR03 8.69464111
USR04 1.6605835
USR05 1.16357422
USR06 1.68048096
6 Zeilen gewählt.