Re: AWR report
Posted by ErmanArslansOracleBlog on Mar 07, 2018; 11:45am
URL: http://erman-arslan-s-oracle-forum.124.s1.nabble.com/AWR-report-tp5338p5343.html
What kind of slowness you mean?
your db is working without stress.
Your DB time is less than or equal to Elapsed time. So your db doesn't do lots of work. It is not utilized heavily.
Please declare that "slowness" and get AWR reports for the related time intervals..
You can increase the frequency of AWR snapshots, thus you can get AWR reports for a 30 min interval or for 15 min interval etc..
Probably, you will need to tune your queries at the end..