Re: Wnnn blockers for grant operation
From: Nenad Noveljic <nenad.noveljic_at_gmail.com>
Date: Sat, 26 Aug 2023 06:09:04 -0400
Message-Id: <BE14F2C1-0890-471C-A09F-7BCB5DD6DD17_at_gmail.com>
Mikhail Velikikh explains how to trace library cache locks here: http://mvelikikh.blogspot.com/2021/02/tracing-library-cache-locks-using.html?m=1
Date: Sat, 26 Aug 2023 06:09:04 -0400
Message-Id: <BE14F2C1-0890-471C-A09F-7BCB5DD6DD17_at_gmail.com>
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-1217 https://dbwhisperer.wordpress.com
-- http://www.freelists.org/webpage/oracle-lReceived on Sat Aug 26 2023 - 12:09:04 CEST