|Mandalika's scratchpad||[ Work blog @Oracle | Stock Market Notes | My Music Compositions ]|
This blog post is generic in nature and based on my recent experience with a content management system where securefile BLOBs are critical in storing and retrieving the checked in content. It is stro ngly suggested to check the official documentation in addition to these brief guidelines. In general, Oracle Database SecureFiles and Large Objects Developer's Guide 11g Release 2 (11.2) is a good starting point when creating tables involving SecureFiles and LOBs.
DISABLE STORAGE IN ROW" (out-of-line) if the average LOB size is expected to be > 4 KB. The default inlining is fine for smaller LOBs
NOCACHE) if large number of LOBs are stored and not expected to be retrieved frequently
COMPRESSoption if storage capacity is a concern and a constraint. It saves disk space at the expense of some performance overhead. In a RAC database environment, it is recommended to compress the LOBs to reduce the interconnect traffic
DEDUPLICATEoption enables sharing the same data blocks for similar files thus reducing storage overhead and simplifying storage management
_use_zero_copy_io=FALSEto turn o ff the Zero-Copy I/O protocol
Oracle Database Documentation : LOB Performance Guidelines