Summary

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 ...

Get Oracle Advanced PL/SQL Developer Professional Guide now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.