Re: Sudden occurrence of SHARED_POOL LATCH waits - DB up since 4/3/2018
From: grzegorzof@xxxxxxxxxx
To: rjoralist3@xxxxxxxxxxxxxxxxxxxxx
Date: Fri, 01 Jun 2018 14:47:51 +0200
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