Re: EM13: Performance issue querying SYSMAN.GC_METRIC_STR_VALUES
- From: Rich J <rjoralist3@xxxxxxxxxxxxxxxxxxxxx>
- To: oracle-l@xxxxxxxxxxxxx
- Date: Fri, 24 Aug 2018 13:26:32 -0500
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
Other related posts: