Re: performance issues

Posted by ErmanArslansOracleBlog on Oct 31, 2023; 1:09pm
URL: http://erman-arslan-s-oracle-forum.124.s1.nabble.com/performance-issues-tp12142p12145.html

You got 16 cores and you are utilizing a significant percentage of them. But it is not a hang situation.
Your main waits are on CPU, and I/O.. You are doing work.
Index read waits are high, but it seems your IO Subsystem is doing okay..

rwrun.. those reports should be tuned. The ones with the sqlids -> 9ks8h2k7sw172, gru84zkj370md
Check your custom code ->  XXHADDAD_PERSONALIZATION_PKG, sqlid 7w5v6kfbc752s
What is that sqlservr.exe doing there? Check the associated query .. (6nuu3b0mjrjr4) It is executed frequently, increasing the load.

See the end of the AWR report.
You got sql tuning recommendations under the title ADDM Task ADDM:3107712059_1_11453 for those relevant SQLs. Consider the recommendation given there.