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
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://asktom.oracle.com/pls/apex/f?p=100:11:0::::P11_QUESTION_ID:9531190000346221457https://stackoverflow.com/questions/49986763/compressing-lob-segments-doesnt-reclaim-space
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)
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)