📋Steps in this guide1/1

space usage by LOB column

SPACE USED BY LOB COLUMN:

oracle configurationintermediate

by OracleDba

12 views

space usage by LOB column

SPACE USED BY LOB COLUMN: ACTUAL SPACE USED BY LOB:

Code/Command (click line numbers to comment):

1
2
3

SELECT s.bytes FROM dba_segments s JOIN dba_lobs l USING (owner, segment_name)
WHERE l.table_name = '&table_name';
SELECT nvl((sum(dbms_lob.getlength( &lob_column ))),0) AS bytes FROM &table_name;

Comments (0)

Please to add comments

No comments yet. Be the first to comment!