| Feature | Pearl | Emerald | Rubin | Diamond |
|---|---|---|---|---|
| Ercole github community support | ✔️ | ✔️ | ✔️ | ✔️ |
| Ercole dedicated support (bug fixing) | ❌ | ✔️ | ✔️ | ✔️ |
| Ercole server and agent deploy | ❌ | ❌ | ✔️ | ✔️ |
| Ercole server and agent maintenance | ❌ | ❌ | ✔️ | ✔️ |
| Oracle database proactive optimization | ❌ | ❌ | ❌ | ✔️ |
| Oracle database licensing optimization assessment | ❌ | ❌ | ❌ | ✔️ |
On the overall database analysis , following areas are evaluated :
- Licensing We will look for an overall view of Oracle RDBMS licenses and options used , unused and due on the actual architecture.
- Run / Governance We will look for what configurations have impacts of database RUN (day by day activities) The target is to locate any issues that could worse RTO (Recovery Time Objective) and RPO (Recovery Point Objective).
- Capacity We will analyze parameters that helps us to understand if actual infrastructure is correctly sized to best support the database workload , highlighting any gap and allocation excesses.
- Performance In this area the attention is oriented to actual database performance highlighting any gap and allocation excesses.
We will create and share a detailed document with all the critical issues and optimization with a gap resolution proposal.
Take your DB environment as safer as possible!
-
Patch management Database PSU/RU installation in order to maintain a 6 months patching window.
-
Space management Defragmentation of top 15 reclaimable space once a month.
-
Performance & tuning Identification of instance performance bottleneck and solution/workaround implementation through ADDM suggestion.