Error ORA-1536 / ORA-21780 occured while spilling buffered messages (Doc ID 1350800.1)

Last updated on MAY 07, 2017

Applies to:

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

Symptoms


Many occurrences of the following errors are observed in alert.log file even with streams processes disabled :

Error ORA-1536 occured while spilling buffered messages
Error ORA-21780 occured while spilling buffered messages

Changes

Messages in a buffered queue are spilled from memory if they have been staged in the buffered queue for a period of time without being dequeued, or if there is not enough space in memory to hold all of the messages. Messages that spill from memory are stored in the appropriate queue table structure.

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