on 09-12-2011 11:11 AM
In SAP note 105047 I can see that "SQL Plan Management" is allowed by SAP. However I don't find information whether the usage of the "Automatic SQL Tuning Advisor" is also allowed? Per default it is disabled on SAP systems.
Regards,
Mark
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Mark,
It is not required for operating SAP. Please see note 974781 on this
Br,
Javier
Hello Javier,
yes, obviously they are not necessary because for SAP systems these jobs are disabled by default:
"These are not necessarily required for operating an SAP system and can therefore be deactivated."
What I would like to know is whether it is allowed to reactivate the "Automatic SQL Tuning Advisor" ?
Hello Mark,
As far as I know yes it is allowed, but the recommendation is to enable it only if really required
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.