Company
Date Published
Sept. 23, 2024
Author
Niju George, Solutions Architect
Word count
790
Language
English
Hacker News points
None

Summary

The Oracle database architecture has undergone significant changes with the release of version 12c, moving from single-tenant databases to multitenant databases. This shift has resulted in changes to the New Relic database monitoring integration to ensure compatibility and provide necessary metrics for both application teams and database administrators. The updates have been made to accommodate the introduction of container databases like Exadata Cloud at Customer (ExaCC) by Oracle, enabling monitoring on host integration to work seamlessly with these databases. The New Relic Oracle Database integration has been redesigned to support both single and multitenant databases, allowing for flexible configuration settings that cater to different user needs, including setting the "SYS_METRICS_SOURCE" flag to connect to either `gv$con_sysmetric` or `gv$sysmetric`. To set up the integration, administrators must provision a database user with specific privileges, deploy the OHI integration, and configure settings according to the required data scope. Once complete, users can log in to the New Relic platform to view instrumented Oracle databases and access performance metrics through curated views or Data Explorer.