DBCollect/AWR Reports

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)