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