I have table that has blob column that is original BasicFiles LOB storage. The main usage of this blob is PDF document files.
As a tidy-up activity, have been looking to see if any options available to improve performance or storage of this data.
As a first step, I can see that I should alter so that blob column is new SecureFiles LOB storage. Documentation says this is new improved LOB storage, plus allows additional options of compression, deduplication, and encryption
The documentation then suggests to enable compression, deduplication, and encryption. Although these options require additional licensing. I am in process of checking if we have the Oracle Advanced Compression Option.
My question is, if do not have Oracle Advanced Compression Option and thus cannot use Advanced LOB Compression, is it still worth considering Advanced Row compression on this blob table?
Thanks