CODEWITHSUNDEEP
oracle-database
SQL Novice
SQL Novice

Reputation: 323

Oracle Change Management and Configuration Management Pack

Is there a query I can run on Oracle to find out if Oracle Change Management or Configuration Management Pack is Installed? I need to run this in our Monitoring Tool for Database Licensing to see if it's installed or not.

I have been looking at other Forums and I haven't come across any information.

PS: I am not a DBA.

Thanks

Upvotes: 0

Views: 494

Answers (1)

pmdba
pmdba

Reputation: 7033

Those "packs" are specifically for Oracle Enterprise Manager. If you aren't running OEM anywhere, then you won't have them installed; if you are, you can verify their enablement through the OEM console.

In general you can monitor the usage of any database-level feature (not OEM feature) through the DBA_FEATURE_USAGE_STATISTICS view. Keep in mind that many separately licensed features cannot be uninstalled. Some can be disabled through other means as I describe in the "Dealing with Unlicensed Features" section of this blog post: https://pmdba.wordpress.com/2020/02/11/understanding-the-af-oracle-esla/. With others, you are on the honor system and must use that view to self-monitor.

Upvotes: 1

Related Questions