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.

How can I disable Diagnostic and Tuning packs in Oracle Database 11g?

April 26, 2017diagnostic disable oracle database packs tuning

0

Posted

How can I disable Diagnostic and Tuning packs in Oracle Database 11g?

1 Answer

0

Posted

Starting with Oracle Database 11g, there is a new init.ora parameter, CONTROL_MANAGEMENT_PACK_ACCESS, that enables/disables Diagnostic and Tuning packs in the database server. This parameter can have three values: DIAGNOSTIC+TUNING (default, both packs are enabled), DIAGNOSTIC (only Diagnostic pack is enabled), NONE (both packs are disabled). In Oracle Database SE/SE1, this parameter is set to ‘NONE’ which disables all pack specific functionality. Users are then free to access AWR as it should only have non-pack data in it. In this case all pack specific views will be empty.