Enhancement Request for Disabling ASH & AWR
- From: "Allen, Brandon" <Brandon.Allen@xxxxxxxxxxx>
- To: "oracle-l" <oracle-l@xxxxxxxxxxxxx>
- Date: Fri, 15 Jun 2007 10:47:14 -0700
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.
--
//www.freelists.org/webpage/oracle-l
Other related posts:
- » Enhancement Request for Disabling ASH & AWR
