Key Elements of onstat -p
Reads %cached - The goal is t> 95%
Writes %cached - The goal is ᢍ%
The BUFFERS parameter in your ONCONFIG file will effect this value.
Be careful, if you make the BUFFERS too large this will take memory away from other processes and may slow down your whole system.
ovlock - This should be zero. Configure using LOCKS parameter in the ONCONFIG file.
ovuserthread - This should be zero. Configure number of user threads in the third value of the NETTYPE parameter
ovbuff - This should be zero. Configure using the BUFFER parameter in the ONCONFIG file.
bufwaits - This should be zero. This indicates the number of times a user thread has waited for a BUFFER.
lokwaits - This should be zero. This indicates the number of times a user thread has waited for a LOCK.
deadlks - This should be zero. This indicates the number of times a deadlock was detected and prevented.
dltouts - This should be zero. This indicates the number of times a distributed deadlock was detected.