Automation & Optimization of Oracle InMemory This article covers in depth analysis to optimize use of InMemory in Oracle. With the latest Oracle releases it has given a significant performance boost with many features like InMemory. InMemory is basically an area in Memory (RAM) that is reserved for use to PERSISTENTLY store data from tables. The data in memory is pushed to InMemory manually and it remains there till we pull it from InMemory giving the developer/dba/Performance tuners a unique opportunity to select the data that they feel needs to be retrieved fast (rather than relying on Oracle engine to select data based on hotness like in case of buffer) When we run a query the optimizer than looks for the data in InMemory, if its able to find the data in InMemory, it pulls the data from InMemory before looking for the data in disks. The IO operations hence are approximately ten times faster and data is retrieved in seconds as compared to minutes needed from disk. Howe...