Operating OnLine 3-83

Monitor OnLine Profile

Monitor OnLine Profile
Monitor the OnLine profile to analyze performance over time. The Profile
screenmaintains cumulative statistics. Use the tbstat -z option whenever you
wish to reset all statistics to 0.
From DB-Monitor
FromDB-Monitor, select the Status menu, Profile option.
The screen display contains 28 separate statistics, as well as the current
OnLine operating mode, the boot time, and the current time.
Thefield labels on the DB-Monitor profile screen are less cryptic and arranged
in a slightly different order than the fields that display if you execute
tbstat -p. However, allDB-Monitor statistics are included in the tbstat -p
output. Refer to page7-92 for a detailed explanation of every field that
displays with this option.
From the Command Line
Fromthe command line, execute, tbstat -p to display 33 separate statistics on
OnLine activity. Thetbstat -p output contains several fields that are not
included in the DB-Monitor display, includingovbuff, which is the number
of times that OnLine exceeded the maximum number of shared-memory
buffers. Theovbuff field is useful in performance tuning. The complete
display is defined on page7-92.
Executetbstat -P to obtain the same statistics as are available with tbstat -p,
plusBIGreads, the number of big-buffer reads.
Refer topage 2-55 for further information about the function of big buffers.