DCD Statistics Viewer Not Showing Correct Values (Doc ID 2055004.1)

Last updated on MARCH 01, 2019

Applies to:

Symptoms

The Statistics Viewer window from GUI is not showing correct values for the newly created DCD statistics; it always shows '0' (please see below picture).
The Statistics Report generated from GUI (SMS Screen / Operator Functions / Report Functions) is accurate meaning that the statistics are saved in the DB, they are correctly transferred from SLCs to SMS and Report show these values.

View Statistics window:

Statistics Report:

History:
SMS provides a system for managing, configuring and viewing statistics and statistical reports. Each application has predefined statistics which are loaded into the SMF_STATS_DEFN table on installation.

Statistics generated by the SMS and SLCs are collected in the SMF_STATISTICS table of the SMF database.

The collection period for individual statistics can be defined dynamically using the SMS Java Administration screens.
The Statistics Viewer screen shows a list of the monitored statistics and allows the list to be edited. A default list of statistics to show are configured. It contains these tabs:
    - Configure Statistics - to add, edit, and delete system statistics. Available system statistics are managed through the statistics management screens.
    - View Statistics - shows a summary of the monitored statistics for each node. Each monitored SLC node is listed along the top of the screen. Under each, there is a line for each statistic (in the same order as in the configuration table). The database is queried periodically to update the displayed values. This period is set in the Configure Statistics screen.

Cause

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.