Login  Register

slow performance

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

slow performance

big
442 posts
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
| More
Print post
Permalink

Re: slow performance

ErmanArslansOracleBlog
Administrator
5727 posts
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.