How to Fine Tuning Database Statistics Calculation for the RUEI Repository (Doc ID 2090050.1)

Last updated on MARCH 16, 2016

Applies to:

APM - Application Performance Management - Version 12.1.0.6.0 and later
Information in this document applies to any platform.

Goal

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:

Solution

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms