regarding suspended notification


what happens when we suspend notification.Trigger will keep on monitor the database for any chnages or not.
if we disable the notification trigger and buffer table will be dropped.
what happens when we suspend it.
plz let me know.


Suspend means that the notification will no longer poll the buffer table for new entries. Thus, new entries will accumulate in the buffer table. The buffer table is not dropped. This is true for all types of notifications.

If your notification is not a basic notification, disabling the notification will drop the buffer table and DB trigger.

For basic notifications, suspending and disabling the notification basically do the same thing–the notification stops polling but the buffer table and DB trigger remain on the DB.