Enhancement Request for Disabling ASH & AWR

Hi List,

I have opened an enhancement request with Oracle Support to provide a fully documented and supported method of disabling the Active Session History, Automatic Workload Repository, ADDM and any other features that can't be used without licensing the Diagnostics Pack. I've seen several others on this list express their frustration with the fact that we're forced to support the overhead of these features on our servers even if we're running Standard Edition database, with which we don't even have the option to license the Diag Pack so we can never legally make use of them. The only ways I know of disabling these features currently are setting statistics_level=basic or setting the hidden parameters _ash_enable=false and _awr_restrict_mode=true, but setting statistics_level=basic also disables several other features that ARE useful w/o the Diag Pack and setting the hidden parameters is of course not documented or supported so it is not a good solution for a production environment.

If you feel the same, please open your own SR/Enhancement Request and reference my ER (#6134859) and hopefully they'll fix this for us.

Thanks,
Brandon

Privileged/Confidential Information may be contained in this message or attachments hereto. Please advise immediately if you or your employer do not consent to Internet email for messages of this kind. Opinions, conclusions and other information in this message that do not relate to the official business of this company shall be understood as neither given nor endorsed by it.

--
http://www.freelists.org/webpage/oracle-l