Happy New Year 2023...! This is a blog for Oracle ERP lovers. BLOG - Begin Learning Oracle with Girish. :-)
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
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