Submit a ticketCall us

WebinarVisual Monitoring Tactics: Getting More Log Search Value from SolarWinds Log & Event Manager with nDepth Webcast

Do things seem to make more sense when they are visualized? Are you an IT professional or security expert with a wish for more cybersecurity tools that provide an intuitive visual experience? Join Alexis Horn and Jamie Hynds from SolarWinds as they demonstrate how the nDepth feature in LEM can help make visualizing log search results a reality.

Register now.

Home > Success Center > Database Performance Analyzer (DPA) > DPA - Knowledgebase Articles > The DPA alert Oracle Stale Statistics is broken

The DPA alert Oracle Stale Statistics is broken

Updated July 26, 2018

Overview

The Oracle Stale Statistics alert returns a list of all tables and indexes that have stale or empty statistics. You may receive Oracle error ORA-12899. Part of the retrieved information is also the owner of the object and the name of the partition, if the table is partitioned. DPA creates a table that allows it to store owner and partition names up to 30 characters long. However, with Oracle 12c and later, the maximum length of those values can be up to 128 characters.

 

If the alert retrieves an object owner name or a partition name that is greater than 30 characters, DPA won't be able to insert that value in the table. This breaks the alert. You can fix the alert manually by connecting to the monitored Oracle instance and extending the width of the column.

Environment

  • DPA, all versions
  • Monitored instance of Oracle 12c or later

Cause 

Oracle increased the maximum length of owner and partition name values to 128 characters. The table that DPA creates to store these values cannot store values longer than 30 characters.

Resolution

  1. Stop DPA.
  2. Connect to the monitored Oracle instance and run the following SQL statements:
    ALTER TABLE ignite_temp_stats MODIFY obj_partition VARCHAR2(128);
    ALTER TABLE ignite_temp_stats MODIFY obj_owner VARCHAR2(128);
  3. Start DPA.

 

 

 

Last modified

Tags

Classifications

Public