Materialized View Refresh Hangs With Pipe Get Idle Event & ORA-28031 Reported In Job Queue Process Trace
Last updated on SEPTEMBER 27, 2013
Applies to:Oracle Database - Enterprise Edition - Version 10.2.0.1 to 22.214.171.124 [Release 10.2 to 11.2]
Information in this document applies to any platform.
Complete non-atomic materialized view refresh hangs with pipe get idle event. The following errors are shown in the job queue process trace file.
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