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>
Date: Fri, 01 Jun 2018 14:47:51 +0200
Message-Id: <dxndsbahbyiiycctpagl_at_xbzj>
Hi, 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-lReceived on Fri Jun 01 2018 - 14:47:51 CEST