Oracle 18c : MEMOPTIMIZE_POOL_SIZE in SGA

Description:- Oracle 18c introduces new feature called MemOptimize pool, a memory area in the system global area (SGA). We can increase the size of the memoptimize pool by manually adjusting the MEMOPTIMIZE_POOL_SIZE initialization parameter. We have use this feature’s to frequently access tables in database level. Those tables are pined into buffer cache using primary … Continue reading Oracle 18c : MEMOPTIMIZE_POOL_SIZE in SGA