Show TOC Start of Content Area

Background documentation JPA Monitors  Locate the document in its SAP Library structure

Use

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.

Prerequisites

You are in the Problem Management ® Database ® JPA Monitors of the SAP NetWeaver Administrator.

Activities

Using the JPA Monitors

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 This graphic is explained in the accompanying text (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).

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.

Note

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.

Customizing the JPA Monitors View

At any time, you can perform one of the following operations:

·        To refresh a list, choose This graphic is explained in the accompanying text (Refresh).

·        To filter long lists, enter a search string in the filter row, then choose ENTER. To show or hide the filter row, choose This graphic is explained in the accompanying text (Show/Hide filter row).

·        To change the size of a list, choose This graphic is explained in the accompanying text (Table settings), then choose the desired list size.

End of Content Area