Re: performance issue on production

Posted by ErmanArslansOracleBlog on Dec 18, 2017; 11:09am
URL: http://erman-arslan-s-oracle-forum.124.s1.nabble.com/performance-issue-on-production-tp4706p4709.html

You have lots of CPU waits. a Cpu bound env..
Please concantrate on "SQL ordered by CPU Time". Concantrate on CPU Time(s).. (there are sqls which have lots of executions, a small optimization that can be done on them, may affect your performance immediately.)

Try to tune the SQLs.

Consider setting sga to an optimal value. (increase)
Also, consider using Hugepages for SGA. (if not already using them, you should configure them immediately.)