Are you facing this issue for which version?
There is a bug in 19c for this.
On Thu, 7 Jan 2021 at 22:33, Amit Saroha <eramitsaroha@xxxxxxxxx> wrote:
Dear All,
In our environment, one program generally errors out while dropping a
materialized view with "ORA-04021: timeout occurred while waiting to lock
object".
This situation is happening at night when no one is monitoring the system.
I am unable to find out why it is happening and if there's any way to view
the programs/sessions using the materialized view that can be identified
anywhere in AWR tables or Alert logs to troubleshoot the issue.
Thank you in advance for all your inputs and support in this matter.
Warm Regards,
A.S.
