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

               App servers can lock the code. That happens frequently here. The answer always is to shut down the app servers.

Liz Reen

From: [External] oracle-l-bounce_at_freelists.org <oracle-l-bounce_at_freelists.org> On Behalf Of [External] Amit Saroha Sent: Thursday, January 7, 2021 12:02 PM To: ORACLE-L (oracle-l_at_freelists.org) Subject: ORA-04021: timeout occurred while waiting to lock object in MView

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