Re: Sudden occurrence of SHARED_POOL LATCH waits - DB up since 4/3/2018

From: <grzegorzof_at_interia.pl>
Date: Fri, 01 Jun 2018 14:47:51 +0200
Message-Id: <dxndsbahbyiiycctpagl_at_xbzj>



Hi,&nbsp;it seems like Oracle created a "better" optimized version of X$KSMSP called X$KSMSP_NWEX for that purpose but not all columns where mapped.Anyway, I wonder if You see large "mvobj part des" allocations in v$sgastat .Regards .Grzegorz

--
http://www.freelists.org/webpage/oracle-l
Received on Fri Jun 01 2018 - 14:47:51 CEST

Original text of this message