HP Intelligent Management Center v5.2 Application Performance Manager Administrator Guide

220
 Submit—Times of the user executing the commit operations during the session when APM last
polled Oracle.
 Cursor—Number of cursors that the user used in the session when APM last polled Oracle.
 Buffer Hit Ratio—How often the logical reading have occurred in the buffer pool.
 More—Click More to view more details about the session.
Waiting Sessions
The Waiting Sessions area layout is shown in Figure 171.
Figure 171 Waiting Sessions area layout
Waiting Sessions area fields:
 ID—ID of the waiting session.
 Username—Username used to establish the session with Oracle.
 Events—Event that the session was waiting, whether for the last time.
 Events Occurred—Number of the same events that sessions were waiting when APM last polled
Oracle.
 State—State of the waiting session when APM last polled Oracle. The available status includes:
 WAITING—The session is waiting.
 WAITED UNKNOWN TIME—The time slot for the waiting session is unknown.
 Type—Session type. BACKGROUND and USER indicate that sessions are generated by the
background process and user process, respectively.
 Wait Seconds—Length of time for which the session had waited when APM last polled Oracle.
DB2
DB2 is an IBM Corporation developed DBMS. The performance and stability can impact the service
applications directly, so APM supports the monitor function to DB2.
APM can monitor the DB2 of the DB2/NT 8.2.0 version and above.
Adding a DB2 application monitor
APM monitors the DB2 application through the service port (5000 by default). When you add
application monitors for DB2, follow these guidelines:
 Add DB2 hosts to the IMC Platform so APM can obtain and display network connections of the
hosts and their access devices in the application topology. For more information about adding hosts
to the IMC Platform, see HP IMC Base Platform Administrator Guide.