lob segment

Posted by Roshan on Dec 12, 2022; 11:54am
URL: http://erman-arslan-s-oracle-forum.124.s1.nabble.com/lob-segment-tp11349.html

Oracle 19c

Hi Erman,

could you please advise how we can reduce the size of LOB segments? This slows down backups and consumes space.

SEGMENT_NAME                                                 BYTES/1024/1024/1024 SEGMENT_TYPE
------------------------------------------------------------ -------------------- ------------------
SYS_LOB0000341432C00005$$                                              3970.51581 LOBSEGMENT
SYS_LOB0000341432C00018$$                                              814.144714 LOBSEGMENT
SYS_LOB0000254819C00005$$                                              422.572449 LOBSEGMENT
SYS_LOB0000341438C00002$$                                              199.181824 LOBSEGMENT

Regards,
Roshan