O'Reilly logo

Oracle Advanced PL/SQL Developer Professional Guide by Saurabh Gupta

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Chapter 9. Caching to Improve Performance

Performance optimization is an immortal challenge in Oracle applications which demands sound essentials of a DBA and logical abilities of a developer. Every release of Oracle promises for new features to enhance the performance and scalability of an application.

In the last chapter, we saw the difference made by real native compilation and intra unit inlining. Another innovation was brought to notice in Oracle 11g and it was data caching. Data caching is a common feature to improvise upon the application performance. In the past, the architectural implementation of caching used to cache the data sets in the SGA buffer cache, but not the SQL with results. Oracle 11g presents a concrete effective feature ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required