Materialized View Refresh Hangs With Pipe Get Idle Event & ORA-28031 Reported In Job Queue Process Trace
(Doc ID 1452844.1)
Last updated on FEBRUARY 02, 2022
Applies to:Gen 1 Exadata Cloud at Customer (Oracle Exadata Database Cloud Machine) - Version N/A and later
Oracle Cloud Infrastructure - Database Service - Version N/A and later
Oracle Database Backup Service - Version N/A and later
Oracle Database Cloud Service - Version N/A and later
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.
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