slow performance

classic Classic list List threaded Threaded
2 messages Options
big
Reply | Threaded
Open this post in threaded view
|

slow performance

big
Hi,
On 19.7C on AIX
Users complain of slowness of DB.

I ran an awr. Can we have some clue from the following ? What is the reason of slowness?





Any advise?
Thanks.
Reply | Threaded
Open this post in threaded view
|

Re: slow performance

ErmanArslansOracleBlog
Administrator
I think this AWR is based on a very narrow time span.
Send me an AWR reports based on a wider range of time, like 30 mins or 1 hour..
Also check Enterprise manager and see the top waits encountered during the slowness.. The graphs on EM performance pages will give you a quick info about the reason.