Re: EM13: Performance issue querying SYSMAN.GC_METRIC_STR_VALUES

On 2018/08/24 08:41, Chris Taylor wrote:

> I don't know of a particular (specific) problem with that view but have some things you could try:
>
> 1. Gather fixed_object_stats
> 2. Gather dictionary stats
> 3. Gather System Stats (either using interval or noworkload if the system isn't regularly busy) (this is where the optimizer gets primary values for many cost calculations)
> 4. If the repository database is 12.1.0.x make sure you disable optimizer_adaptive_features

Hey Chris,

The OMS repository is 12.2, so 1 and 2 are automagic now, as I'm running the auto stats job. Number 3, however, is interesting. They're only half collected (NW), so that could have some effect. I'll give it a shot.

Thanks, Chris! And thanks to Kellyn, too!

Rich

--
http://www.freelists.org/webpage/oracle-l