My Oracle Support Banner

Load Profile Adapter Taking Up to 24 Hours to Load Profiles and Also Filling the Temp Tablespace (Doc ID 2767540.1)

Last updated on APRIL 08, 2021

Applies to:

Oracle Utilities Network Management System - Version 2.4.0.1.0 to 2.5.0.1.0 [Release 2.4 to 2.5]
Oracle Network Management for Utilities - DMS - Version 2.4.0.1.0 to 2.5.0.1.0 [Release 2.4 to 2.5]
Information in this document applies to any platform.

Symptoms

On : 2.5.0.0.0 version, NMS Infrastructure

Load Profile adapter taking upto 24 hours to load profiles and also giving error for temp tablespace:

 

The customer is collecting temperature based loading data for 16 months and creating load profiles for each of their feeders.  Each feeder on their model will have profiles for 16 months with one csv file for each month.   The time taken to load profiles is taking upwards of 24+ hours


While loading the profiles,  there is also an error being generated as the TEMP  tablespace gets maxed out.

ORA-01652: unable to extend temp segment by 128 in tablespace NMSADMIN_TMP




Changes

 

Cause

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
Symptoms
Changes
Cause
Solution
 Fix Description
 Migration
 Suggested Test
References


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