Re: SecureFile Mutex waits

I forgot to say that if you're seeing something reported as mutex waits then you could check the v$mutex_sleep, v$mutex_sleep_history of the AWR report as that might give you some clue about the nature of the mutexes that are being waited for, and that might give you a clue about the underlying activity that's triggering the problem.

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