Progress
Database Administration
Guide and Reference


Activity Displays>Summary

Displays general information about database activity. Figure A–21 shows a sample Summary Activity display.

01/25/02       Activity: Summary 
16:27          from 01/25/02 15:31 to 01/25/02 16:04 (2 min. 48 sec.) 
Event           Total   Per Sec.    Event          Total   Per Sec. 
Commits          1208       0.7     DB Reads         57        0.0 
Undos               0       0.0     DB Writes         3        0.0 
Record Reads     1334       0.8     BI Reads         13        0.0 
Record Updates   1208       0.7     BI Writes       131        0.0 
Record Creates   0          0.0     AI Writes         0        0.0 
Record Deletes   0          0.0     Checkpoints       0        0.0 
Record Locks     3625       2.3     Flushed at chkpt  0        0.0 
Record Waits        0       0.0 
Rec Lock Waits  0%    BI Buf Waits     0%     AI Buf Waits   0% 
Writes by APW   0%    Writes by BIw    96%    Writes by AIW  0% 
DB Size:        352K  BI size:         512K   AI Size:       0K 
Empty blocks:   10    Free blocks:     0      RM chain:      1 
Buffer hits:    98%   Active trans:    1 
0 Servers, 1 Clients (1 Local, 0 Remote, 0 Batch), 1 APWs 

Figure A–21: PROMON Summary Activity Display

The Summary Activity display shows the number of events that have occurred on the system, including the cumulative total and the number of events per second. The display includes the following events:

The Summary Activity display also shows the following information:

The last line of the Summary Activity display summarizes the current number of each type of process running against the database at the time you run the Activity option. Table A–10 defines the process types.

Table A–10: Process Types 
Field
Description
Servers
Number of servers running against your database. This is the current value at the time you run the Activity option, not a cumulative total.
Clients
Number of client sessions running. This field is further divided into the type of user: Local, Remote, or Batch. This is the current value at the time you run the Activity option, not a cumulative total.
APWs
Number of APWs running against your database. This is the current value at the time you run the Activity option, not a cumulative total.


Copyright © 2004 Progress Software Corporation
www.progress.com
Voice: (781) 280-4000
Fax: (781) 280-4095