Cache Messages with Singleton Pipes and Using Pipes for Persistent Messaging

On Autonomous AI Database the DBMS_PIPE package includes support for Singleton Pipes and Persistent Messaging Pipes.

• Singleton Pipes allow you to cache and retrieve a custom message and share the message across multiple database sessions with concurrent reads.

• Persistent Messaging Pipes allow you to store messages in Cloud Object Storage. Using persistent messages you can send and receive messages within a single database or between multiple databases in the same or in different regions, without message size limitations.