Oracle Database Discussions

HI,

Lob segment size shows lesser than the actual lob column size of the table.

Table is not paritioned. SEGMENT_CREATED='YES' and stats gathered last week.

XML_COL                        CLOB  

Please advise.

DB Version:11.2.0.3

Lob segment size (3 MB) shows lesser than the actual lob column (2580 MB)

select BYTES/1024/1024 SIZE_MB from dba_segments where segment_name='T_ORDER_XML_COL';

3

SELECT ROUND(SUM(dbms_lob.getlength(XML_COL)/1024/1024)) SPACE_USED_MB FROM T_ORDER;

2580

Regards,

Veera