Important Notice: Our web hosting provider recently started charging us for additional visits, which was unexpected. In response, we're seeking donations. Depending on the situation, we may explore different monetization options for our Community and Expert Contributors. It's crucial to provide more returns for their expertise and offer more Expert Validated Answers or AI Validated Answers. Learn more about our hosting issue here.

Does Automatic SQL Tuning feature implement any recommendations besides SQL profiles? Why not?

April 26, 2017automatic feature implement Profiles recommendations sql tuning

0

Posted

Does Automatic SQL Tuning feature implement any recommendations besides SQL profiles? Why not?

1 Answer

0

Posted

The Automatic SQL Tuning feature in Oracle Database 11g only implements SQL profile recommendations. This is because a SQL profile is the easiest to test, impacts only one SQL statement, and is the most lightweight to implement on a production system (vs gathering statistics,creating indexes, etc).