Check the space occupied by the LOB Field

Query the space occupied by the LOB field query the space occupied by the LOB field in the Oracle table. Each LOB field in the table is stored independently on a segment with an index segment. Therefore, you need to query two segments to obtain the total space occupied. SQL code www.2cto.com select. owner,. table_name,. column_name, B. segment_name, ROUND (B. BYTES/1024/1024) from dba_lobs a, dba_segments B where. segment_name = B. segment_name and. owner = 'xxx' and. table_name = 'yyyy' union all select. owner,. table_name,. column_name, B. segment_name, ROUND (B. BYTES/1024/1024) from dba_lobs a, dba_segments B where. index_name = B. segment_name and. owner = 'xxx' and. table_name = 'yyyy'