We see some performance benefit in using Materialized Views in our OLTP environment. We are using MV logs and ROWID MVs - in the absence of explicitly defined primary keys on the base tables - understand that it is advisable not to use ROWID MVs.

Looking out for information about the maintenance activities that need to be carried out for MVs - yet to find the same in the docs. In the meantime, I thought I could raise it up here so that those who are using MVs in their environment can share their experience on the same.

Thanks in advance.