Last updated on MAY 07, 2017
Applies to:Oracle Database - Enterprise Edition - Version 10.2.0.4 to 220.127.116.11 [Release 10.2 to 11.2]
Information in this document applies to any platform.
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
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.
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
Million Knowledge Articles and hundreds of Community platforms