Re: ITL waits in the dictionary
From: Norman Dunbar <oracle_at_dunbar-it.co.uk>
Date: Wed, 20 Nov 2019 20:54:18 +0000
Message-ID: <E1F88C82-A0CB-426C-9EA9-DD0759CD5000_at_dunbar-it.co.uk>
Date: Wed, 20 Nov 2019 20:54:18 +0000
Message-ID: <E1F88C82-A0CB-426C-9EA9-DD0759CD5000_at_dunbar-it.co.uk>
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
Received on Wed Nov 20 2019 - 21:54:18 CET