My Oracle Support Banner

MSRFWOR Performance Issue 10g Running with Refresh Method Complete ORA-12008 ORA-30036 (Doc ID 443396.1)

Last updated on JULY 12, 2021

Applies to:

Oracle Advanced Supply Chain Planning - Version 11.5.9 and later
Information in this document applies to any platform.
EXECUTABLE:MSRFWOR - Refresh Collection Snapshots



Symptoms

On 11.5.9 in Production:
When running Refresh Collection Snapshots concurrent request as a standalone request in source
instance with Refresh Method: Complete, snapshots: ALL_Snapshots, it errors after 5 hours with
the following error occurs. ( see l13810572.req )

ERROR
Snapshot Owner = BOM
Primary Table = BOM_BILL_OF_MATERIALS
ORA-12008: error in materialized view refresh path
ORA-30036: unable to extend segment by 8 in undo tablespace 'APPS_UNDO_TBS_16'
ORA-12008: error in materialized view refresh path
ORA-30036: unable to extend segment by 8 in undo tablespace 'APPS_UNDO_TBS_16'


STEPS
The issue can be reproduced at will with the following steps:
1. In source instance: run Refresh Collection Snapshots concurrent request

BUSINESS IMPACT
The issue has the following business impact:
Due to this issue, users cannot run Refresh Collection Snapshots with Refresh Method: Complete.

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
References

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