How to monitor Oracle ExaCC databases using New Relic

Since the release of Oracle Database version 12c, the architecture has transitioned from single-tenant to multitenant databases, introducing pluggable containers (PDBs) for application-specific data and root containers (CDBs) for system-wide performance data. This architectural shift led to adaptations in New Relic's database monitoring integration, ensuring compatibility with both single and multitenant Oracle databases by configuring the “SYS_METRICS_SOURCE” flag to access appropriate metrics from either PDBs or CDBs, thus enhancing observability for application teams and database administrators. Furthermore, changes in Oracle's database structure, such as the migration of system metrics to gv$con_sysmetric, required updates to New Relic’s on-host integration, which now requires specific setup steps, including user provisioning and configuration adjustments, to enable seamless access to performance metrics on the New Relic platform.