Error ORA-1536 / ORA-21780 occured while spilling buffered messages
(Doc ID 1350800.1)
Last updated on JANUARY 07, 2020
Applies to:Oracle Database - Enterprise Edition - Version 10.2.0.4 to 220.127.116.11 [Release 10.2 to 11.2]
Oracle Database Cloud Schema Service - Version N/A and later
Oracle Database Exadata Express Cloud Service - Version N/A and later
Oracle Database Exadata Cloud Machine - Version N/A and later
Oracle Cloud Infrastructure - Database Service - Version N/A and later
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.
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