Top10 sql by execution duration – H3C Technologies H3C Intelligent Management Center User Manual
Page 286
272
Figure 225 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.
Top10 SQL by Execution Duration
The Top10 SQL by Execution Duration area displays top 10 SQL statements by accumulated execution
duration.
Figure 226
Top10 SQL by Execution Duration
area layout
Top10 SQL by Execution Duration area fields:
•
SQL—SQL statement.