Oracle : Intersession Communication

Share this post!

Vote this!

Intersession communication is the ability to communicate between two different user connections, you have two ways in which you can communicate between sessions

• DBMS_PIPE
• DBMS_ALERT

Normally in order for two session to communicate you can use would use a permanent structure (table) to allow one session to access data in other, for instance you could use table to exchange data, however this is controlled by transaction control limitations, the transaction must complete and be comitted before the other user can see the data.
In order to communicate between two session without using a permanent structure and use memory instead (SGA) you can use and do the following:  more...