Oracle designed their Database In-Memory Option specifically for these sorts of scenarios. But it's a fairly crudely designed column store cache and MemSQL are right to bash them.

But the strength of Oracle remains OLTP and I don't see customers fleeing to MemSQL for this.