Re: awr report

Posted by ErmanArslansOracleBlog on Apr 25, 2018; 10:56am
URL: http://erman-arslan-s-oracle-forum.124.s1.nabble.com/awr-report-tp5767p5768.html

There is a super minimal wait for network.
So, you should concantrate on CPU & enq:TM contention waits.
For CPU, check the SQL ordered by CPU section.
For Enq TM waits; Enq TM waits are caused by missing Foreign Key (FK) index on the FK constraint columns in the Child tables. Check : Locking and Referential Integrity (Doc ID 33453.1) & Resolving Issues Where 'enq: TM - contention' Waits are Occurring (Doc ID 1905174.1)

Also, read my AWR related blog post to get a better idea about AWR interpreting;

http://ermanarslan.blogspot.com.tr/2014/05/awr-analysis-part-1.html