My Oracle Support Banner

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 11.2.0.2 [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.

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

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
Symptoms
Changes
Cause
Solution


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.