Enterprise Manager for Oracle TimesTen In-Memory Database User's Guide
ContentsOpens a new window
Opens a new window
Page 16 of 21

12 Working with the Cache Synchronization Metrics Page

This chapter describes the Cache Synchronization Metrics page.

Topics include:

Viewing the cache synchronization metrics page

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 GuideOpens a new window.

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"Opens a new window.

From the TimesTen Database Home menu, select Monitoring, then select Cache Synchronization Metrics.

Analyzing the cache synchronization metrics page

Figure 12-1Opens a new window 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"Opens a new window in the Oracle TimesTen Application-Tier Database Cache User's Guide.

Figure 12-1 Cache Synchronization Metrics tabs

Description of Figure 12-1 follows
Description of "Figure 12-1 Cache Synchronization Metrics tabs"Opens a new window

A description of each area follows:

Cache AWT

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"Opens a new window 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:

Cache AWT

Figure 12-2 Cache AWT region

Description of Figure 12-2 follows
Description of "Figure 12-2 Cache AWT region"Opens a new window

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"Opens a new window 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"Opens a new window in the Oracle TimesTen In-Memory Database Reference.

AWT transactions propagated to the Oracle database

Figure 12-3 AWT Transactions Propagated to the Oracle Database region

Description of Figure 12-3 follows
Description of "Figure 12-3 AWT Transactions Propagated to the Oracle Database region"Opens a new window

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.

AWT transactions committed on Oracle database

Figure 12-4 AWT Transactions Committed on Oracle Database region

Description of Figure 12-4 follows
Description of "Figure 12-4 AWT Transactions Committed on Oracle Database region"Opens a new window

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.

AWT batch performance

Figure 12-5 AWT Batch Performance region

Description of Figure 12-5 follows
Description of "Figure 12-5 AWT Batch Performance region"Opens a new window

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"Opens a new window in the Oracle TimesTen In-Memory Database Reference.

AWT volume (MB/sec)

Figure 12-6 AWT Volume (MB)/sec region

Description of Figure 12-6 follows
Description of "Figure 12-6 AWT Volume (MB)/sec region"Opens a new window

The AWT volume (MB/sec) region uses a line graph to show the AWT volume in Megabytes per second.

Cache parallel AWT

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"Opens a new window 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"Opens a new window in the Oracle TimesTen Application-Tier Database Cache User's Guide. The cache parallel AWT tab is divided into two sub-tabs:

Performance

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:

AWT lag

Figure 12-7 AWT Lag region

Description of Figure 12-7 follows
Description of "Figure 12-7 AWT Lag region"Opens a new window

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"Opens a new window in the Oracle TimesTen In-Memory Database Troubleshooting Guide.

AWT bytes sent

Figure 12-8 AWT Bytes Sent region

Description of Figure 12-8 follows
Description of "Figure 12-8 AWT Bytes Sent region"Opens a new window

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"Opens a new window in the Oracle TimesTen In-Memory Database Reference.

AWT batch performance

Figure 12-9 AWT Batch Performance region

Description of Figure 12-9 follows
Description of "Figure 12-9 AWT Batch Performance region"Opens a new window

The AWT batch performance region uses a line graph to show the number of full and partial batches applied per second.

AWT transactions

Figure 12-10 AWT Transactions region

Description of Figure 12-10 follows
Description of "Figure 12-10 AWT Transactions region"Opens a new window

The AWT transactions region uses a line graph to show the number of commits and transactions per second.

Tracks

The tracks sub-tab provides performance information about parallel AWT tracks. The tracks sub-tab is divided into two regions:

Parallel AWT tracks

Figure 12-11 Parallel AWT Tracks region

Description of Figure 12-11 follows
Description of "Figure 12-11 Parallel AWT Tracks region"Opens a new window

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"Opens a new window 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"Opens a new window.

Transactions processed on Oracle database

Figure 12-12 Transactions Processed on Oracle database region

Description of Figure 12-12 follows
Description of "Figure 12-12 Transactions Processed on Oracle database region"Opens a new window

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.

Cache autorefresh

The cache autorefresh tab enables you to view performance information of read-only cache groups. This tab is divided into three regions:

Cache autorefresh

Figure 12-13 Cache Autorefresh region

Description of Figure 12-13 follows
Description of "Figure 12-13 Cache Autorefresh region"Opens a new window

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.

Readonly cache

Figure 12-14 Readonly Cache region

Description of Figure 12-14 follows
Description of "Figure 12-14 Readonly Cache region"Opens a new window

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"Opens a new window 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"Opens a new window.

Updates pending refresh

Figure 12-15 Updates Pending Refresh region

Description of Figure 12-15 follows
Description of "Figure 12-15 Updates Pending Refresh region"Opens a new window

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.