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

Hello Amit,

For this you have ASH.

You can used Tanel`s wait chains, might help you: https://github.com/tanelpoder/tpt-oracle/blob/master/ash/dash_wait_chains.sql

În joi, 7 ian. 2021 la 19:18, <dimensional.dba_at_comcast.net> a scris:

> If your v$active_session_history is large enough to cover your nightly
> period when you come in, in the morning.
>
> You could look at the time period of errors and see what sql_ids were
> active at that time and look at the objects the sql_ids are touching to see
> if it is the materialized view in question.
>
>
>
> *From:* oracle-l-bounce_at_freelists.org <oracle-l-bounce_at_freelists.org> *On
> Behalf Of *Amit Saroha
> *Sent:* Thursday, January 7, 2021 9:02 AM
> *To:* ORACLE-L (oracle-l_at_freelists.org) <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