Monitoring the Shared-Memory Profile

Home | Previous Page | Next Page Disk, Memory, and Process Management > Managing Shared Memory > Monitoring Shared Memory >

Monitoring the Shared-Memory Profile

Monitor the database server profile to analyze performance and the use of shared-memory resources. The Profile screen maintains cumulative statistics on shared-memory use. To reset these statistics to zero, use the onstat -z option.

Using Command-Line Utilities

Execute onstat -p to display statistics on database server activity. Figure 44 shows these statistics.

Figure 44. onstat -p Output

Profile
dskreads pagreads bufreads %cached dskwrits pagwrits bufwrits %cached
382      400      14438    97.35   381      568      3509     89.14

isamtot  open     start    read     write    rewrite  delete   commit   rollbk
9463     1078     1584     2316     909      162      27       183      1

ovlock   ovuserthread ovbuff   usercpu  syscpu   numckpts flushes
0        0            0        13.55    13.02    5        18

bufwaits lokwaits lockreqs deadlks  dltouts  ckpwaits compress seqscans
14       0        16143    0        0        0        101      68

ixda-RA  idx-RA   da-RA    RA-pgsused lchwaits
5        0        204      148        12

Using SMI Tables

Query the sysprofile table to obtain shared-memory statistics. This table contains all of the statistics available in onstat -p output except the ovbuff, usercpu, and syscpu statistics.