Re: ORA-04021: timeout occurred while waiting to lock object in MView

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_at_gmail.com> 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.
>

--
http://www.freelists.org/webpage/oracle-l