space usage by LOB column - Oracle Database Script.
SPACE USED BY LOB COLUMN:
SELECT s.bytes
FROM dba_segments s
JOIN dba_lobs l USING (OWNER,
segment_name)
WHERE l.table_name = '&table_name';
ACTUAL SPACE USED BY LOB:
SELECT nvl((sum(dbms_lob.getlength(&lob_column))),0) AS bytes
FROM &TABLE_NAME;