Pages

OracleEBSpro is purely for knowledge sharing and learning purpose, with the main focus on Oracle E-Business Suite Product and other related Oracle Technologies.

I'm NOT responsible for any damages in whatever form caused by the usage of the content of this blog.

I share my Oracle knowledge through this blog. All my posts in this blog are based on my experience, reading oracle websites, books, forums and other blogs. I invite people to read and suggest ways to improve this blog.


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