Using JPA Monitors

Administrate the JPA Monitors

Choose the Monitoring Actions pushbutton, then choose the relevant administrative operation.

You can start, stop, pause, or reset the JPA Monitors statistics.

Find an entity by name

Choose the pushbutton, enter a search string in the Find Entity field, then choose Go .

Monitor a given persistence unit

Select the persistence unit of interest in the List of Persistence Units area.

You can group the persistence units list by cluster nodes or by applications, using the Group By dropdown list.

The available information for the selected persistence unit appears in the Details About the Persistence Unit area.

Monitor the entities within a selected persistence unit

1. Choose the Entities tab.

   For each entity, you can monitor the following parameters: Name , Fields , Operations , DB Operations , DB Time (ms) , Avg DB Time (ms) .

   Note

   The Entities tab provides information about entity manager operations and cascaded operations.

2. To view the READ or WRITE operations performed on a given entity, select the entity, then choose the corresponding tab in the Entity Operations on the Entity area.

Monitor the relationships within the selected persistence unit

1. Choose the Relationships tab.

2. To view information about the SQL statements triggered by any relationship navigation of the client code, select the relationship.

Monitor the queries performed on entities within the persistence unit

1. Choose the Queries tab.

2. To modify the maximum number of queries to be logged, choose Modify , enter a custom value, then choose Save .

Monitor the currently active persistence contexts within the selected persistence unit

Choose the Persistence Contexts tab.

Monitor the JPA caches

1. Choose the Caches tab.

   The following cache types are available:

   • OBJECT_CACHE - used for the implementation of the ReadOnly entity feature. Contains all read-only entities of the monitored persistence unit.

   • QUERY_RESULT_CACHE - stores the results of JPQL queries and native queries which have the hint Constants.CACHE_QUERY_RESULTS=Constants.CACHE_QUERY_RESULTS.CACHED set.

   • SQL_STATEMENT_CACHE - stores SQL statements that are computed by SAP JPA during runtime.

   • SQL_MAPPING_METADATA - stores metadata needed for mapping of entity manager operations and JPQL queries to SQL statements.

     More information: Caches in the JPA Implementation

2. You can clear each cache or modify its size:

   • To clear a cache, select the cache, then choose the Clear Cache pushbutton.

   • To modify the size of a particular cache, select the cache, then choose Modify Cache Size , enter a custom value, then choose Save .