Using ON-Monitor to Monitor Sessions (UNIX)

Enterprise Edition Home | Express Edition Home | Previous Page | Next Page Improving Individual Query Performance > Monitoring Sessions and Threads >

Using ON-Monitor to Monitor Sessions (UNIX)

Choose User from the Status menu. This option provides a subset of the information that the onstat -u utility displays. The following information appears:

The session ID
The user ID
The number of locks that the thread is holding
The number of read calls and write calls that the thread has executed
Flags that indicate the present state of the thread (for example, waiting for a buffer or waiting for a checkpoint), whether the thread is the primary thread for a session, and what type of thread it is (for example, user thread, daemon thread, and so on)

For sample output, see Figure 84.

Figure 84. Output from the User Option of the ON-Monitor Status Menu

                             USER THREAD INFORMATION

                          Locks        Disk       Disk        User thread
 Session   User           Held         Reads      Writes      Status

      0    informix           0           96           2       ------D
      0    informix           0            0           0       ------F
      0    informix           0            0           0       -------
     15    informix           0            0           0       Y-----M
      0    informix           0            0           0       ------D
     17    chrisw             1            3          34       Y------