Re: SecureFile Mutex waits

Which version of Oracle ?

I don't KNOW anything about it. Is this information coming from trace files or from the active session history. If the latter can you identifiy the blocking session; if the former can you seen any patterns to the (undocumented) p1, p2, p3 parameters.

I'd guess this is something to do with the Wnnn processes triggered by the SMCO process to pre-allocate space for the LOB segments, and the Wnnn processes blocking each other, or the SMCO being blocked. (Sorry, just hand-waving). Do you have any parameter settings that might allow too many or too few Wnnn processes to run; or a configuration that means you are working hard to release "old" LOBs because you've managed to set a hard limit the size of the LOB segment, or a very small retention time.

Regards
Jonathan Lewis

On Thu, 22 Sept 2022 at 12:23, Satalabaha Oracle < satalabaha.oracle_at_gmail.com> wrote:

> Hi.
>
> There's a table with a securefile LOB column that gets INSERTS and DELETES
> a lot. We see "SecureFile mutex" waits for the deletes statement which
> seems to block the insert statement causing write timeout (10 seconds). I
> am not able to find much information on SecureFile mutex waits. If anyone
> has any experience around this, please do share..
>
> --
> Thanks,
> Satalabaha
>

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