Autonomous MView Log Shrinkage
With version 12.2 there seems to have a some change in behavior of Materialised View Logs which caught us by surprise; I haven’t seen it documented elsewhere, so let me demonstrate. My test instance is un-patched 12.2.0.1 running on Oracle Linux. For the setup, I create a table, a mview log on that table, a …