Insights into Statistics, Query Optimization and the Oracle Optimizer

New SQL Plan Management White Paper

Nigel Bayliss
Product Manager

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 )
  • Chuck Tuesday, May 23, 2017
    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.
  • Nigel Bayliss Wednesday, May 24, 2017
    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.
Please enter your name.Please provide a valid email address.Please enter a comment.CAPTCHA challenge response provided was incorrect. Please try again.