RE: Anyone Using In-Memory?

> Has anyone played with this?

Yes. Actually, I spent quite a lot of time with it, i.e. more than just "playing" ;-). That said, I don't have many customers using it. You'll not get tons of replies...

> Is it difficult to use?

Basically, no. But, as always, details might be important. A good example of that is described in this blog post<https://danischnider.wordpress.com/2017/10/25/oracle-database-in-memory-and-hash-ke>. It was written by a colleague of mine based on a non-obvious problem that we hit by one of our customer's implementation.

So, when correctly used, the performance improvements can be huge. But, understanding how it works is important.

> We are on Oracle 12.1.0.2

I would strongly advise you to do a PoC with 12.2. So many improvements were implemented in 12.2 that, IMO, 12.1.0.2 should no longer be considered for In-Memory deployments... remember, 12.1.0.2 was the very first release of In-Memory.

HTH
Chris Antognini

Troubleshooting Oracle Performance, Apress 2008/2014

--
http://www.freelists.org/webpage/oracle-l