Symptoms

On : 1.12.0.3.22 or 2.3.0.01, MBService takes an extremely long time to initialize when the model has more than 200,000 primary views to load from a single table.It spends an inordinate amount of time in AlternateViewManager::load().

Even after 15 minutes, there is no corresponding MBS-00203 entry in the log file, which would indicate that the alternate views had finished loading.

Add the counts from the following query to determine the count of primary views:select 'network_components '||count(1) from alternate_views a, network_components b where b.h_cls = a.h_cls and b.h_idx = a.h_idx and b.death is null and a.death is null unionselect 'network_nodes '||count(1) from alternate_views a, network_nodes b where b.h_cls = a.h_cls and b.h_idx = a.h_idx and b.death is null and a.death is null unionselect 'object_instances '||count(1) from alternate_views a, object_instances b where b.h_cls = a.h_cls and b.h_idx = a.h_idx and b.death is null and a.death is null;

MBService should start in a reasonable amount of time.

The issue can be reproduced at will with the following steps:1. Start services.2. Check the MBService log for "AlternateViewManager::load()" entries.

Changes

NMS was recently patched to 1.12.0.3.22 or 2.3.0.0.1

Cause

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