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@xxxxxxxxxxxxxxx> 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.
