Information from onstat in the SMI Tables

To obtain information provided by the onstat utility, you can use SQL to query appropriate SMI tables. The following table indicates which SMI tables to query to obtain the information provided by a given onstat option. For descriptions of the onstat options, see Monitor the database server status.
onstat Option SMI Tables to Query onstat Fields Not in SMI Tables
-d sysdbspaces syschunks address bpages
-D sysdbspaces syschkio  
-F sysprofile address flusher snoozer state data
-g ath systhreads  
-g dri sysdri Last DR CKPT (id/pg)
-g glo sysvpprof Listing of virtual processors by
-g ipl sysipl  
-g rss sysrsslog systrgrss syssrcrss  
-g his syssqltracing  
-g sds syssrcsds systrgsds  
-g smx syssmx  
-g smx ses syssmxses  
-k syslocks address lklist tblsnum
-l syslogs sysprofile All physical-log fields (except numpages and numwrits) All logical-log buffer fields (except numrecs, numpages, and numwrits) address begin % used
-p sysprofile  
-u syssessions syssesprof address wait nreads nwrites

Copyright© 2018 HCL Technologies Limited