Summary

In this chapter, you learned how to handle large objects in Oracle. You now understand the dynamics of storing large objects in a database. A detailed discussion on the optimization features of Oracle SecureFiles would have helped you to differentiate the two storage approaches. The comparative illustration of a BasicFile and SecureFile will help in deducing the appropriate conclusions.

Moving forward, the next chapter will deal with another important aspect of database programming, that is, tuning the PL/SQL code. Tuning—an indispensable part of programming—is a skill for writing optimized code, which comes from knowledge and matures with experience.

Get Advanced Oracle PL/SQL Developer's Guide - Second Edition 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.