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

From: Amit Saroha <eramitsaroha_at_gmail.com>
Date: Thu, 7 Jan 2021 12:01:58 -0500
Message-ID: <CAG67e6QAvSoCoSUcnL13YQRSpgMPGeH-YzMQXAUdv_91u6-K9w_at_mail.gmail.com>



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
Received on Thu Jan 07 2021 - 18:01:58 CET

Original text of this message