My Oracle Support Banner

Refresh Order Management Materialized Views Poor Performance and Error FDPSTP Failed Due to ORA-12008: Error in Materialized View Refresh Path (Doc ID 2801719.1)

Last updated on DECEMBER 10, 2024

Applies to:

Oracle Order Management - Version 12.2 and later
Information in this document applies to any platform.

Symptoms

“Refresh Order Management Materialized Views”   concurrent program performance poor taking upwards of 4-6 hours to complete
when previously it was only taking 1.5 to 2 hours to complete successfully.


Following Expensive SQL identified in tkprof:

 


STEPS
-----------------------

1. Responsibility: Order Management Super User
2. Run concurrent request "Refresh Order Management Materialized Views"
3. Observe poor performance issue.

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.