tnzk
Davide Golinelli, October 04, 2016 - 7:28 am UTC
i've done a quick view and it seems just what I need!
i've googled a lot about the topic but didn't foud anything
tnkz a lot
Davide Golinelli, October 04, 2016 - 8:17 am UTC
October 04, 2016 - 11:32 am UTC
Here's what I am thinking
1) trigger on "huge event" table
fires off dbms_aq.enqueue, with sufficient details for downstream processing (might just be the primary key, with perhaps a flag for why we're enqueueing, eg ins/upd/del)
2) program running as a daemon (you would write this).
endless loop
- dbms_aq.dequeue;
- with msg, do the downstream processing
- commit;