Skip to Main Content

Enterprise Manager

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

EM12c Access Advisor Results timeout

chris.baronAug 28 2013

I'm sure there's a tweak of some sort that can be applied here, and I figure this will be the place to get some help.

I've run the SQL Access advisor on a 7 node RAC cluster and admittedly didn't filter anything resulting in a rather large set. However, though I can get to the access advisor task summary page that tells me it has various bits of wonderful improvements, when I try to access the Recommendations tab/or by clicking the link at the bottom of the page, it takes forever and a day, and then times out.

Now, this cluster is in another DC than the OEM setup so there is some network latency involved, but is there some sort of tweak I can apply to speed this up? I'm a bit surprised that the recommendations tab isn't a "show me the top guys first, then allow me to click next page in decreasing order of improvement" sort of thing.

I'm going to create an SR as well, but thought some folks here would have run into something similar.

Thanks in advance for any pointers.

Cheers.

Comments

Processing
Locked Post
New comments cannot be posted to this locked post.

Post Details

Locked on Sep 25 2013
Added on Aug 28 2013
0 comments
117 views