Pages

Thursday, February 28, 2013

What is the difference between SQL profiles, stored outlines, and SQL plan baselines?


What is the difference between SQL profiles, stored outlines,
and SQL plan baselines?

To achieve SQL plan stability in earlier releases of Oracle Database stored outlines played a
major role. In Oracle Database 11g they are still supported, however will be deprecated in the
future releases in favor of SQL plan management.

The goal of SQL plan baselines (that are generated by the SQL plan management mechanism) is to preserve the performance of corresponding SQL statements, regardless of changes in the database.

SQL Profiles, on the other hand, were introduced in Oracle Database 10g and were supposed to
guide the Optimizer to a better plan. They do not guarantee the same plan each time the 
statement is parsed.

http://www.oracle.com/technetwork/database/manageability/sql-profiles-technical-overview-128535.pdf

1 comment:

  1. All given info was wonderful and it's very helpful for everyone.I read your post is very nice thank you..........Please contact us for Oracle Financials Training in Ameerpet details in our Erptree Training Institute

    ReplyDelete