Re: SecureFile Mutex waits

Hello,
you can also use Tanel Poder‘s mutex profiler script, if you want to be more granular.

https://raw.githubusercontent.com/tanelpoder/tpt-oracle/master/mutexprof.sql

Best Regards
Stefan Koehler

Independent Oracle performance consultant and researcher Website: http://www.soocs.de
Twitter: _at_OracleSK

> Jonathan Lewis <jlewisoracle_at_gmail.com> hat am 23.09.2022 15:51 CEST geschrieben:
>
>
> 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