Re: ITL waits in the dictionary

Agree with Norm. This seems like CTD to me.

These statistics are for the lifetime of the instance. How long has the instance been up? Is 1,049 more than a blip on the radar? My guess is no....

-Mark

On Wed, Nov 20, 2019, 15:55 Norman Dunbar <oracle_at_dunbar-it.co.uk> wrote:

> Hi Mladen,
>
> If you increase initrans it will help with any new blocks but not with the
> old. However, what actual performance issue are you seeing/experiencing?
> Try running an AWR report and see what actual effect those 1049 waits have
> had on your system.
>
> If it's small, does it need worrying about, if it's large, log an SR and
> see what Oracle says. I'd avoid mucking about in the dictionary except
> under orders!
>
>
> Cheers,
> Norm.
> --
> Sent from my Android device with K-9 Mail. Please excuse my brevity.

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