Materialized View Refresh Hangs With Pipe Get Idle Event & ORA-28031 Reported In Job Queue Process Trace (Doc ID 1452844.1)

Last updated on SEPTEMBER 27, 2013

Applies to:

Oracle Database - Enterprise Edition - Version 10.2.0.1 to 11.2.0.3 [Release 10.2 to 11.2]
Information in this document applies to any platform.

Symptoms

Complete non-atomic materialized view refresh hangs with pipe get idle event. The following errors are shown in the job queue process trace file.

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