DBCollect/AWR Reports: Difference between revisions

From Dirty Cache Wiki
Jump to navigation Jump to search
No edit summary
No edit summary
Line 1: Line 1:
[[Category:DBCollect]]
[[Category:DBCollect]]
{{stub}}
= Overview =
= Overview =


Line 10: Line 11:
Diagnostics Pack is a licensed option on top of Oracle Database Enterprise Edition. It is required to run AWR reports. You can run AWR reports without the license, however, this will be registered in the database and is a licensing violation that can have consequences when customers are audited. Therefore, {{dbcollect}} has some safeguards against accidental usage.
Diagnostics Pack is a licensed option on top of Oracle Database Enterprise Edition. It is required to run AWR reports. You can run AWR reports without the license, however, this will be registered in the database and is a licensing violation that can have consequences when customers are audited. Therefore, {{dbcollect}} has some safeguards against accidental usage.


{{stub}}
= Detecting Diagnostics Pack license =
 
It is impossible to detect contract details using automated tools on a host. Therefore, {{dbcollect}} checks for previous usage of AWR Reports instead. See [https://oracle-base.com/articles/misc/tracking-database-feature-usage Oracle Base - Tracking Database Feature Usage] for a detailed explanation and example script.
 
If prior AWR Usage is detected, then either the system is licensed with Diagnostics Pack, or (worst case scenario) the system is in license violation anyway. In both cases, {{dbcollect}} will proceed creating AWR reports (unless disabled via CLI parameters)

Revision as of 11:16, 24 May 2024

This article is a stub. You can help us by expanding it.

Overview

By default, dbcollect tries to generate AWR reports for each detected and running database instance on the host.

However, creating AWR reports require the Oracle Diagnostics Pack license. This page explains how dbcollect deals with this requirement.

Diagnostics Pack

Diagnostics Pack is a licensed option on top of Oracle Database Enterprise Edition. It is required to run AWR reports. You can run AWR reports without the license, however, this will be registered in the database and is a licensing violation that can have consequences when customers are audited. Therefore, dbcollect has some safeguards against accidental usage.

Detecting Diagnostics Pack license

It is impossible to detect contract details using automated tools on a host. Therefore, dbcollect checks for previous usage of AWR Reports instead. See Oracle Base - Tracking Database Feature Usage for a detailed explanation and example script.

If prior AWR Usage is detected, then either the system is licensed with Diagnostics Pack, or (worst case scenario) the system is in license violation anyway. In both cases, dbcollect will proceed creating AWR reports (unless disabled via CLI parameters)