VIEW: SYS.DBA_KEEPSIZES

Source

View Text - Preformatted

select trunc((sum(parsed_size)+sum(code_size))/1024),
         owner, name
  from dba_object_size
  where type in ('PACKAGE','PROCEDURE','FUNCTION','PACKAGE BODY','TRIGGER',
                 'JAVA SOURCE','JAVA CLASS','JAVA RESOURCE','JAVA DATA')
  group by owner, name

View Text - HTML Formatted

SELECT TRUNC((SUM(PARSED_SIZE)+SUM(CODE_SIZE))/1024)
, OWNER
, NAME
FROM DBA_OBJECT_SIZE
WHERE TYPE IN ('PACKAGE'
, 'PROCEDURE'
, 'FUNCTION'
, 'PACKAGE BODY'
, 'TRIGGER'
, 'JAVA SOURCE'
, 'JAVA CLASS'
, 'JAVA RESOURCE'
, 'JAVA DATA') GROUP BY OWNER
, NAME