I have a materialized view that gets refreshed concurrently every 10 seconds (b/c it contains time sensitive stuff). At times it appears to get backed up so there are multiple refreshes queued and then gets stuck waiting for a lock? Does anybody know if this is expected behavior? Am I supposed to be manually managing to ensure that only one refresh is being requested at a time?
Thanks,
Xiao
