Performance information that the onstat utility displays

The onstat utility displays a wide variety of performance-related and status information contained within the SMI tables. You can use the onstat utility to check the current status of the database server and monitor the activities of the database server.

For a complete list of all onstat options, use the onstat - - command. For a complete display of all the information that onstat gathers, use the onstat -a command.
Tip: Profile information displayed by onstat commands, such as onstat -p, accumulates from the time the database server was started. To clear performance profile statistics so that you can create a new profile, run the onstat -z. If you use onstat -z to reset statistics for a performance history or appraisal, ensure that other users do not also enter the command at different intervals.

The following table lists some of the onstat commands that display general performance-related information.

Table 1. onstat commands that display performance information
onstat command Description
onstat -p Displays a performance profile that includes the number of reads and writes, the number of times that a resource was requested but was not available, and other miscellaneous information
onstat -b Displays information about buffers currently in use
onstat -l Displays information about the physical and logical logs
onstat -x Displays information about transactions, including the thread identifier of the user who owns the transaction
onstat -u Displays a user activity profile that provides information about user threads including the thread owner's session ID and login name
onstat -R Displays information about buffer pools, including information about buffer pool page size.
onstat -F Displays page-cleaning statistics that include the number of writes of each type that flushes pages to disk
onstat -g Requires an additional argument that specifies the information to be displayed

For example, onstat -g mem displays memory statistics.

For more information about options that provide performance-related information, see Monitoring fragmentation with the onstat -g ppf command and Monitor database server resources.

Copyright© 2018 HCL Technologies Limited