Insights into Statistics, Query Optimization and the Oracle Optimizer
-
SQL Plan Management
January 30, 2017
New SQL Plan Management White Paper
A new white paper for SQL Plan Management is now available. Just go to the Query Optimization page in OTN and click the SQL Plan Management with Oracle Database link.
Just like the Optimizer white paper, I've kept the content and format similar to the way Maria organized it so that it will be familiar to those of you that have read previous versions.
Post comments to this blog if you want to give me feedback on the white paper's content. If you want more examples, let me know and I'll add suggestions to my to-do list.
Join the discussion
Comments ( 2 )
-
Is there any documentation regarding limitations, restrictions, recommendations, or best practices for the use of SPM within database heavily constrained with Virtual Private Database policies restricted tables and views? My SYS_AUTO_SQL_TUNING_TASK is flooded with ORA-28113 and ORA-00936 errors because the policy exempt SYS cannot run the application queries it is trying to evaluate.
-
Hi Chuck, no there isn't. It's hard to imagine how there could be a best practice solution applicable to many (IMO). In the example you give, isn't this an issue with auto SQL tuning? I'll get in touch with you and we can discuss further.