The JPA monitors provide information about all JPA applications that are running on a given cluster.
The information is grouped by the existing persistence units.
You are in the Problem Management ® Database ® JPA Monitors of the SAP NetWeaver Administrator.
The following tasks can be performed using the JPA Monitors function:
Task |
Steps |
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 (Show query form), 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).
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.
Typically, you can view information about hanging transaction scoped persistence contexts or about extended persistence contexts, as the usual lifetime of the transaction scoped persistence contexts is too short. |
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. |
At any time, you can perform one of the following operations:
· To refresh a list, choose (Refresh).
· To filter long lists, enter a search string in the filter row, then choose ENTER. To show or hide the filter row, choose (Show/Hide filter row).
· To change the size of a list, choose (Table settings), then choose the desired list size.