Hi Team,
Could you please help me understand the procedure of getting the rows and inserting it to the buffer table during insert notifications.
I mean… which component is responsible in getting this task done.
Thanks in advance.
Rows get inserted into the buffer table by DB triggers.
Who creates the triggers, and what they triggered for, depends upon the type of notification you use.
Review the documentation for additional details.
IME, you’ll want to only use Basic notification type and avoid the insert, update, delete types. The reason is it lets you manage the DB triggers rather than having the IS notification manage them (meaning, create or drop them). If you use a type other than basic, if you disable the notification, the triggers will be dropped which usually is NOT what you want.
Even I suggest to use Basic Notification against insert, update or delete notifications as a user you own the control over it.