Re: Mview refresh when involved table is locked

Sorry to say, but your test case isn't the problem you're having in production. You say there are 10+ tables involved and multiple materialised views? Sounds like you need to understand what is actually happening, rather than trying to reproduce a small part of it that will work in isolation.

We need more information to help.

Cheers,

Phil

On Thu, Nov 21, 2013 at 10:16 PM, Eriovaldo Andrietta <ecandrietta_at_gmail.com
> wrote:

> Hi,
>
> I am facing this problem.
>
> When the refresh COMPLETE ON DEMAND of a mview starts via job
> (automatically from user_jobs), as schedulled and some tables (at least
> 10) used in the mview are locked , the refresh also keep in a recursive
> lock and anything more run ...
>
> I need to kill sessions to release process...
>
> Among these objects used in the mview, I have tables and also others
> mviews (with refresh ON COMMIT) , so , some MLOG$_ are locked.
>
> The refresh of mview try to execute this command and stays stopped.
> /* QSMQ VALIDATION */ ALTER SUMMARY "SCHEMA001"."MATVIEW001" COMPILE
>
>
>
> Regards
> Eriovaldo
>
>

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