Re: RAC performance issue

Posted by ErmanArslansOracleBlog on Aug 05, 2017; 4:32pm
URL: http://erman-arslan-s-oracle-forum.124.s1.nabble.com/RAC-performance-issue-tp3099p3105.html

interesting.

tps stands for Transactions Per Second (ie IOPS).
use iostat -x for a more detailed output.
Read this for the quick info: https://dom.as/2009/03/11/iostat/

Consider using iotop for finding the cause. (read this: http://bencane.com/2012/08/06/troubleshooting-high-io-wait-in-linux/)

Check the OS of that node, and see there is no problematic disk device. ( I mean lost IOs making the process D state - http://ermanarslan.blogspot.com.tr/2013/08/linux-d-state-processes.html)

Check the processes as a whole, there may be some backup programs running. Use top to check the heavy processes in the first place.