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.
| 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.