This chapter explained a new orientation of LOB handling in Oracle. It is introduced in Oracle 11g R1 and known as SecureFile. The chapter explained the concept and its architectural enhancements. We learned the working of SecureFiles and its advanced features. We understood the enabling of the compression, deduplication, and encryption features. Finally, we covered the migration of BasicFile LOBs to SecureFile LOBs to reap the benefits of a sparking feature.
Since implementation of a filesystem in the database is not limited with the introduction of Oracle SecureFiles, further reading should be continued to realize the strengths and application of SecureFiles. Implications of SecureFiles can be observed in RAC environments, information lifecycle management, database filesystem (DBFS), and content management schemes. Further reading can be continued from the following links:
