Monitoring True Cache with Oracle Enterprise Manager

Discovery

True Caches can be discovered in Enterprise Manager manually or using Auto Discovery. For details, see Discovering and Adding True Cache in Oracle Enterprise Manager Monitoring Guide.

Monitoring

Once the primary database and True Caches are discovered and added, you can use Enterprise Manager to monitor their health and performance. If you have configured multiple True Caches for a single primary (a one-to-many setup), you can use Enterprise Manager to view the topology and obtain a comprehensive overview of the primary database and all its associated True Caches. From the Configuration Topology view, you can navigate to the Home page of a True Cache to view graphs that display transport lag, apply lag, and hit ratios. This lets you assess how current and efficient the cache is.

Metrics

Enterprise Manager provides standard database performance and usage metrics and key True Cache-specific metrics. True Cache metrics in Enterprise Manager include Database Load, Memory Usage, and True Cache Hit Ratios and Lags. Having these metrics readily available in the user interface enables you to quickly detect performance degradations and lag, and proactively fix issues. For details on the True Cache metrics in Enterprise Manager, see True Cache in Oracle Enterprise Manager Oracle Database Metric Reference Manual.

Performance Hub

Starting with Oracle Enterprise Manager 24ai Release 1 Update 7 (24.1.0.7), you can use Performance Hub in Enterprise Manager to monitor database activity, diagnose issues, and tune queries to improve True Cache performance.

You can use the following Performance Hub features with True Cache:

ASH Analytics: Displays Active Session History (ASH) analytics charts that you can use to explore ASH data. In the ASH Analytics tab, you can select an Average Active Sessions dimension and view the top activity for that dimension for the selected time period.
SQL Monitoring: Displays a table that lists monitored SQL statements by dimensions, such as Last Active Time, CPU Time, Database Time, and so on. The SQL Monitoring tab provides information about SQL statements that are currently running and SQL statements that completed, failed, or were terminated.
SQL History: Provides granular statistics on all the SQL executions in the database. The table in the SQL History tab displays the top 500 executions by completion time along with information such as status, session ID, completion time, duration, SQL ID, SQL plan hash, user name, service, module, action, parallel execution, database time, and SQL text.

For details, see Using Performance Hub to Analyze Database Performance in Oracle AI Database Performance Tuning Guide.

6.4 Monitoring True Cache with Oracle Enterprise Manager