Re: Wnnn blockers for grant operation

THanks all. Problem is it happened once and then did not replicate and I was trying to find a plausible reason.

I observed the blocking chain from ASH.

În sâm., 26 aug. 2023 la 13:10, Nenad Noveljic <nenad.noveljic_at_gmail.com> a scris:

> Mikhail Velikikh explains how to trace library cache locks here:
> http://mvelikikh.blogspot.com/2021/02/tracing-library-cache-locks-using.html?m=1
>
> Best regards, Nenad
>
> Von meinem iPhone gesendet
>
> Am 25.08.2023 um 21:53 schrieb Mladen Gogala <gogala.mladen_at_gmail.com>:
>
> 
> On 8/25/23 01:21, Laurentiu Oprea wrote:
>
> Dear oracle community,
>
> Can anyone help me with an opinion on why Wnnn processes waiting for "db
> file sequential read" will block some grant operations which are waiting
> for "library cache lock"?
>
> Appreciate your answers.
>
> I don't know, especially since you haven't listed the version and the
> platform. Is there a reason why you cannot activate 10046 trace on the
> process? Wnnn processes are space management slave processes. This has
> already been discussed in detail, by Nenad Noveljic. I suggested tracing
> Wnnn processes to Nenad as well. When I go to the archive and look for
> those old posts I see Tanel and Jonathan clearing things up for Nenad.
>
> The discussion can be found at:
> https://www.freelists.org/post/oracle-l/reads-by-KTSJ,8
>
> --
> Mladen Gogala
> Database Consultant
> Tel: (347) 321-1217https://dbwhisperer.wordpress.com
>
>

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