/* ORACLE */ :::Schema DB-objects size: SELECT s.segment_name | SergeyGurin

/*
ORACLE
*/

:::Schema DB-objects size:
SELECT s.segment_name,
s.segment_type,
CASE
WHEN s.segment_type = 'LOBSEGMENT'
THEN
(SELECT l.table_name ' -> ' l.column_name
FROM dba_lobs l
WHERE l.owner = s.owner
AND l.segment_name = s.segment_name
)
ELSE ''
END lob_info,
s.tablespace_name,
SUM (ROUND (bytes / 1024 / 1024 / 1024, 1)) AS GB,
s.owner
FROM dba_segments s
WHERE s.owner = 'OWNER'
GROUP BY s.segment_name, s.segment_type, s.tablespace_name, s.owner
ORDER BY GB DESC;