How to Fine Tune Database Statistics Calculation for the RUEI Repository
(Doc ID 2090050.1)
Last updated on MARCH 10, 2018
Applies to:APM - Application Performance Management - Version 22.214.171.124.0 and later
Information in this document applies to any platform.
Real User Experience Insight (RUEI) sometimes makes use of the Oracle Database in such a way where the table statistics framework, designed to optimize SQL performance, is actually causing congestion in the database.
This document provides some tuning that can be done to the statistics framework to prevent this.
An example scenario may be that the RUEI Event log reports:
At the same time, the AWR report of that time-frame reports the following SQL as the top consumer:
To view full details, sign in with your My Oracle Support account.
Don't have a My Oracle Support account? Click to get started!
In this Document