O'Reilly logo

Oracle Database 11gR2 Performance Tuning Cookbook by Ciro Fiorillo

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

Managing stored outlines

In production environments, there is a very simple golden rule about database performance—it's better to have a database that always performs quite well than a database that performs even 10 times faster but not always; that is, a database whose performance sometimes dips.

Execution plan stability is a must for ensuring performance that persists over time; in production environments, we need an optimal and predictable performance.

In this recipe, we will see how to create stored outlines to achieve execution plan stability and how to manage these stored outlines.

Getting ready

To create stored outlines, we need an appropriate grant. Connect to the database as SYSDBA, and grant the user SH permission to create stored outlines: ...

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