Oracle In-Memory Column Store: Eviction Predictability Limits for Mixed INMEMORY_PRIORITY Workloads
A mixed analytic workload needs reliable response times for both hot tables marked INMEMORY_PRIORITY CRITICAL and ad-hoc tables set to NONE. The goal is to size the IM column store so that critical segments remain resident while on-demand segments can be evicted without destabilizing query latency. However, Oracle documents that INMEMORY_PRIORITY governs pop