How to find space usage of lob segments in Oracle database
Generally A select from the BYTES column in DBA_SEGMENTS for the table shows the table segment and its size. select bytes/1024/1024 ,segment_name from dba_segments where segment_name=’&1′ and segment_type=’TABLE’; But does not include LOB (CLOB or BLOB) segments sizes.To calculate the total size for the table and the associated LOBS segments a sum of the following …
How to find space usage of lob segments in Oracle database Read More »
