This chapter describes the Cache Synchronization Metrics page.
Topics include:
The cache synchronization metrics shows cache specific performance information. In order to view the metrics, ensure that you have configured a cache environment for your TimesTen target and ensure that the cache agent is up. For more information on configuring a cache environment, see the Oracle TimesTen Application-Tier Database Cache User's Guide.
To view the cache synchronization metrics, ensure that you are on the TimesTen target page. For information on navigating to the TimesTen target page, see "Navigating to the TimesTen target page".
From the TimesTen Database Home menu, select Monitoring, then select Cache Synchronization Metrics.
Figure 12-1 shows two cache synchronization metrics tabs that have been customized for TimesTen cache environments. Click a specific tab to view detailed cache synchronization metrics information.
Note:
Only one of these tabs is available at a time: Cache Parallel AWT or Cache AWT. If you have set cache AWT parallelism, Enterprise Manager displays the Cache parallel AWT tab. If you have not set cache AWT parallelism, Enterprise Manager displays the Cache AWT tab. For more information on cache AWT parallelism, see "Configuring parallel propagation to Oracle Database tables" in the Oracle TimesTen Application-Tier Database Cache User's Guide.Figure 12-1 Cache Synchronization Metrics tabs
A description of each area follows:
Note:
The Cache AWT tab is only available if you have not set cache AWT parallelism. For more information on cache AWT parallelism, see "Configuring parallel propagation to Oracle Database tables" in the Oracle TimesTen Application-Tier Database Cache User's Guide.The cache AWT tab enables you to view performance information of AWT cache groups. It is divided into five regions:
The cache AWT region shows the number of transactions committed on the Oracle database and the number of transactions rolled back on the Oracle database. The number of batches sent, bytes sent, rows deleted, rows inserted, and rows updated on the Oracle database for the SQL array execution method and the PL/SQL execution method of AWT cache are also displayed. The performance data is derived from values in the SYS.SYSTEMSTATS
system table. For more information, see "SYS.SYSTEMSTATS" in the Oracle TimesTen In-Memory Database System Tables and Views Reference.
The method determines whether TimesTen uses the PL/SQL execution method or the SQL array execution method to apply changes to the Oracle database server for asynchronous writethrough propagation.
For more information about AWT cache methods, see "TimesTen Cache first connection attributes" in the Oracle TimesTen In-Memory Database Reference.
Figure 12-3 AWT Transactions Propagated to the Oracle Database region
The AWT transactions propagated to the Oracle database region uses a line graph to show the number of AWT transactions propagated to the Oracle database per second.
Figure 12-4 AWT Transactions Committed on Oracle Database region
The AWT transactions committed on Oracle database region uses a line graph to show the number of AWT transactions committed on the Oracle database per second.
The AWT batch performance region uses a line graph to show AWT Batch performance represented as a rate of rows per batch. SQL array execution mode is set with CacheAWTMethod
=0 and PL/SQL execution mode is set with CacheAWTMethod
=1. For more information on CacheAWTMethod
, see "CacheAWTMethod" in the Oracle TimesTen In-Memory Database Reference.
The AWT volume (MB/sec) region uses a line graph to show the AWT volume in Megabytes per second.
Note:
The Cache parallel AWT tab is only available if you have set cache AWT parallelism. For more information on cache AWT parallelism, see "Configuring parallel propagation to Oracle Database tables" in the Oracle TimesTen Application-Tier Database Cache User's Guide.The cache parallel AWT tab displays track and performance information about AWT cache groups that are configured with parallel propagation. For more information on parallel propagation for AWT cache groups, see "Configuring parallel propagation to Oracle Database tables" in the Oracle TimesTen Application-Tier Database Cache User's Guide. The cache parallel AWT tab is divided into two sub-tabs:
The performance sub-tab provides performance information about AWT cache groups that are configured with parallel propagation. The performance sub-tab is divided into four regions:
The AWT lag region uses a line graph to show the number of AWT transactions propagated to the Oracle database and generated on the TimesTen database per second.
It is important that the number of AWT transactions propagated to the Oracle database match the number of AWT transactions generated on the TimesTen database. For more information on troubleshooting AWT performance, see "AWT performance monitoring" in the Oracle TimesTen In-Memory Database Troubleshooting Guide.
The AWT bytes sent region uses a line graph to show the bytes sent per batch in SQL mode and PLSQL mode per second. SQL array execution mode is set with CacheAWTMethod
=0 and PL/SQL execution mode is set with CacheAWTMethod
=1. For more information on CacheAWTMethod
, see "CacheAWTMethod" in the Oracle TimesTen In-Memory Database Reference.
The AWT batch performance region uses a line graph to show the number of full and partial batches applied per second.
The AWT transactions region uses a line graph to show the number of commits and transactions per second.
The tracks sub-tab provides performance information about parallel AWT tracks. The tracks sub-tab is divided into two regions:
The Parallel AWT tracks region shows the performance of the various parallel AWT tracks. Parallel AWT tracks are set with the CacheAWTParallelism
connection attribute. For more information on the CacheAWTParallelism
connection attribute, see "CacheAWTParallelism" in the Oracle TimesTen In-Memory Database Reference.
Click a peer name to review the number of transactions processed on the Oracle database for the parallel AWT track. The number of transactions processed on the Oracle database for the parallel AWT track display in the transactions processed on Oracle database region. For more information on the transactions processed on Oracle database region, see "Transactions processed on Oracle database".
Figure 12-12 Transactions Processed on Oracle database region
The transactions processed on Oracle database region uses a line graph to show the number of transactions processed on the Oracle database for the parallel AWT track.
The cache autorefresh tab enables you to view performance information of read-only cache groups. This tab is divided into three regions:
The cache autorefresh region shows the number of rows deleted, inserted, and updated in TimesTen from the Oracle database. The number of cycles that completed successfully and the number of cycles that failed on TimesTen are also displayed. TimesTen starts collecting these metrics when the TimesTen database is loaded into memory.
The readonly cache region displays information about the last autorefresh operations of each of the read-only cache groups of your TimesTen database. For more information on read-only cache groups, see "Read-only cache group" in the Oracle TimesTen Application-Tier Database Cache User's Guide.
Click a cache group ID to review the number of updates pending refresh. The number of updates pending refresh display in the updates pending refresh region. For more information on the updates pending refresh region, see "Updates pending refresh".
Figure 12-15 Updates Pending Refresh region
The updates pending refresh region shows a line graph with the number of updates pending refresh for your specified cache group in the last hour.