Disable ADDM In 10g

Of course, versions 10 and were normal this support. but there are still plenty of them in production environments. Also many of these are migrated to version 11 or 12, but other many remain as historical. One feature I am observing that is becoming common and depending on license political to customer with Oracle is relative to ADDM. I have received requests to disable this feature / tool.

If you read the manual, it says to put off the ADDM must configure the STATISTICS_LEVEL to BASIC. Which is correct, but it is less clear or does not say that putting this parameter to BASIC, puts disable many other features of tuning that are free. This is put sticks in the wheels.

The solution specific to this version, the following versions this changes, is using a hidden parameter;

ALTER SYSTEM SET “_ADDM_AUTO_ENABLE”=FALSE;

HTH – Antonio NAVARRO

Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s