My Oracle Support Banner

Improving Model Build Performance with Managing Index Statistics and Purging Old Inactive Model Data (Doc ID 1385163.1)

Last updated on APRIL 03, 2023

Applies to:

Oracle Network Management for Utilities - DMS - Version 1.7.1.1 and later
Oracle Utilities Network Management System - Version 1.7.1.1 and later
Information in this document applies to any platform.

Purpose

How can Model Build Performance be improved by Managing Index Statistics and Purging Old Inactive Model Data?


Additional data purging related KM Documents:

<Document 884501.1> What Information Does DDService Manage?

DMS changes in order of changes to the product:
<Document 2482167.1> What Happened to the Script "product_dms_purge_history.ces" in 2.3.0.1?
<Document 2530797.1> NMS PURGE_HISTORY_TABLES_JOB Failing
<Document 2562242.1> PURGE_HISTORY_TABLES_JOB Causing CORBA Timeouts
Database Partitioning related bug <Document 2651788.1> After Calling "Action any.DDService purge_history", Several Database Indices Become UNUSABLE

Questions and Answers

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
Purpose
Questions and Answers
 Does removing inactive records from the model improve Model Build performance?
 The best ways to improve performance
 Why does the POINT_COORDINATES table have over 2 million active rows?
 NMS v2.3.0 and prior releases:
 What impact on system performance and system stability does the mb_purge script have?
 Is it possible to minimize such impact?
 What are some detailed examples?
References


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