How reliable data from AQ$wf_notification_out is?
Good day to you all.
I ran datewise count on wf_notifications table and aq$wf_notification_out view, for the last 30 days.
I see that the view returns only for a handful of days, whereas wf_notifications table has data for each day.
Q1: Isn't any record that has to be sent out will find listed in the view?
If yes, then how come we see only a handful?
Q2: Which table captures that email has been sent out of oracle? If it is aq$wf_notifications_out then why so many records are missing?
Thanking you in advance