AbdelhakOracle Enterprise Manager 13c OEM
This report provides a detailed overview of the replication and capacity planning for Oracle databases. It includes critical metrics such as the number of replicated databases, archive logs generated, and specific details for each instance.
Capacity Planning Details
Summary
| Number of Replicated Databases | Archive Logs Generated (MB) |
|---|---|
| 29 | 2254.74 |
Detailed Report
| Timestamp | Instance Name | Primary Sequence | Max Transfer Sequence | Transfer Gap | Apply Gap | Gap Hours | Archive Generated (MB) | Error DG |
|---|---|---|---|---|---|---|---|---|
| 2024-02-02T16:02:00.000+01:00 | Instance1 | 11137 | 0 | 11137 | 11137 | 0 | 305.38 | 0 |
| 2024-02-02T15:58:00.000+01:00 | Instance2 | 81 | 0 | 81 | 81 | 0 | 0 | 0 |
| 2024-02-02T16:02:00.000+01:00 | Instance3 | 544556 | 544555 | 1 | 1 | 0 | 6.65 | 16 |
| 2024-02-02T17:01:00.000+01:00 | Instance4 | 29325 | 29325 | 0 | 1 | 17 | 0 | 0 |
| 2024-02-02T17:01:00.000+01:00 | Instance5 | 11942 | 11942 | 0 | 1 | 13 | 0 | 0 |
| 2024-02-02T17:01:00.000+01:00 | Instance6 | 7113 | 7113 | 0 | 1 | 20 | 0 | 0 |
| 2024-02-02T17:01:00.000+01:00 | Instance7 | 16612 | 16612 | 0 | 1 | 19 | 0 | 0 |
| 2024-02-02T16:02:00.000+01:00 | Instance8 | 286147 | 286147 | 0 | 1 | 2 | 2.27 | 0 |
Behind the Scenes
Collaborating with the Database Team
Creating this report was a collaborative effort. The database team provided the necessary SQL queries for monitoring the database replication. My role was to tweak and optimize these queries to ensure they ran efficiently.
Transitioning to Oracle Analytics
A significant part of this project was transitioning the existing queries from Oracle BI Publisher to Oracle Analytics. The data sources for these reports were from Oracle Enterprise Manager (OEM), providing a robust foundation for our reporting needs.
Challenges Faced
One of the significant challenges was making the reports comprehensive yet easy to understand for various stakeholders. Balancing technical details with clear, concise summaries required careful planning and iteration. Additionally, integrating data from different sources and ensuring consistency across reports was a complex task that demanded meticulous attention to detail.
What's Next?
This Capacity Planning Report is just one part of our ongoing efforts to enhance our database management capabilities. In the coming weeks, I’ll be sharing more detailed reports, each focusing on different aspects of our database management system. These articles will delve into the specifics of each report, discussing the purpose, methodology, tools used, and the challenges faced.
Stay tuned for these detailed explorations, where I will share insights and tips that can help you in your database management endeavors.
