Oracle 21c on Windows 11 64-bit laptop.
In our application, we use LOBs to store data as follows:
Blobs - storing month-end statements, customer characters, usually containing bitmap images, company logos, etc.
Clobs - storing large text-only data
The data in these LOBs is usually very static after initial creation; if a change is required, we usually delete the existing LOB and create a new one.
Is it worthwhile to store these LOBs in a separate tablespace, wondering about additional I/O required to access these LOBS.
Opinions, please.
Thanks
Murray