Oracle Virtualization and Cloud Consulting
view counter

enq: JI - contention

Thanks to Rob van Wijk for this story

To implement entity rules and inter-entity rules, one of the options is to use an on commit-time fast refreshable materialized view with a check constraint on top. You can read a few examples in these posts. It's an elegant way to check for conditions at commit-time, and quite remarkable when you see it for the first time. But there is a serious caveat to this way of implementing business rules,

Oracle Virtualization and Cloud Consulting
view counter

Read the entire article at its source

view counter