Introduction:
Oracle database always comes up with additional licensing for extra features and most prominent feature is Diagnostics and Tuning pack.
These packs are controlled by database parameters and some customers will enable this by default without having Diagnostics and tuning pack license.
We will see in detail here about these packs.
Most of us know Oracle Diagnostic and Tuning pack is required to Use AWR and ADDM reports. But what we miss to know are what other features requires these licenses. Here we will see what else are eligible in those packs.
What covers in Diagnostics Pack License?
Oracle Diagnostics Pack includes the following features:
- Performance monitoring and diagnostics (database and host)
- Automatic Workload Repository (AWR)
- AWR Warehouse
- Automatic Database Diagnostic Monitor (ADDM)
- Compare Period ADDM
- Real Time ADDM
- Active Session History (ASH)
- ASH analytics
- Performance Hub
- Exadata Cell Grid Administration
- Exadata Cell Grid Performance
- Exadata Cell Group Health Overview page
- Exadata Resource Utilization
- Blackouts
- Notifications
- Metric and Alert/Event history
- User-Defined Metrics and Metric Extensions
- Management Connectors
- Dynamic metric baselines and Adaptive metric thresholds
- Monitoring templates and Template Collections
- Replay Compare Period Report
- Supporting functionality to perform per stream bottleneck detection and per component top wait event analysis
What covers in Tuning Pack License?
Oracle Tuning Pack includes the following features:
- SQL Access Advisor
- SQL Tuning Advisor
- Oracle Database In-Memory Advisor
- Automatic SQL Tuning
- SQL Profiles
- Real-time SQL and PL/SQL Monitoring
- Real-time Database Operations Monitoring
- Reorganize objects
Common Mistakes:
As we see, we have numerous features enabled once we buy Diagnostics and Tuning pack, many DBA’s or customers without knowing the impact of Oracle Auditing, we tend to use these features using Enterprise managers by running SQL tuning for SQL Id, create AWR and ADDM reports etc.
We should always ensure that we comply with Oracle licensing before using such features.
We will see what parameter controls these feature in next post.
