Re: Mview refresh when involved table is locked
- From: Phillip Jones <phil@xxxxxxxxxx>
- To: Eriovaldo Andrietta <ecandrietta@xxxxxxxxx>
- Date: Thu, 21 Nov 2013 23:48:12 +0000
Hi,
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@xxxxxxxxx
> 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
>
>
Other related posts: