Oracle LOBs
BasicFiles vs SecureFiles...
BasicFiles vs SecureFiles...
BasicFiles do not support compression, deduplication or encryption features.
SecureFiles do not support Shrink (only Move)
NOTE:Compression and deduplication require the Advanced Compression Option.Encryption requires the Advanced Security Option.
Check
Check
Unused Space
Unused Space
Used Space
Used Space
Shrink
Shrink
ALTER TABLE &mytable MODIFY LOB(&mylob) (SHRINK SPACE);
ALTER TABLE &mytable MODIFY LOB(&mylob) (SHRINK SPACE CASCADE);
Bibliography
Bibliography
https://community.oracle.com/tech/developers/discussion/888380/finding-which-table-a-lob-belongs-tohttps://oracle-base.com/articles/misc/alter-table-shrink-space-onlinehttps://www.morganslibrary.org/reference/pkgs/dbms_space.htmlhttps://www.psoug.org/reference/dbms_space.htmlhttps://asktom.oracle.com/pls/apex/f?p=100:11:0::::P11_QUESTION_ID:9531190000346221457https://stackoverflow.com/questions/49986763/compressing-lob-segments-doesnt-reclaim-spacehttps://www.bobbydurrettdba.com/2023/02/20/lob-space-scripts/https://nguyentichthanh.wordpress.com/how-to-determine-the-actual-size-of-the-lob-segments-and-how-to-free-the-deletedunused-space-abovebelow-the-hwm-doc-id-386341-1/
https://docs.oracle.com/cd/E11882_01/appdev.112/e18294/adlob_smart.htm
https://support.oracle.comDBMS_SPACE.SPACE_USAGE Behavior On BASICFILE LOB (Doc ID 2212957.1)ORA-10614 Running DBMS_SPACE on LOB with ASSM Segment Space Management (Doc ID 1669501.1)
https://docs.oracle.com/cd/E11882_01/appdev.112/e18294/adlob_smart.htm
https://support.oracle.comDBMS_SPACE.SPACE_USAGE Behavior On BASICFILE LOB (Doc ID 2212957.1)ORA-10614 Running DBMS_SPACE on LOB with ASSM Segment Space Management (Doc ID 1669501.1)