Oracle In-Memory is such a great feature – but often the challenge you’ll face is the tricky question:
Which of your tables and/or partitions should you mark for In-Memory column store availability?
And the answer is now easier to find as the new In-.Memory Advisor is available via download from MyOracle Support:
The Advisor produces a report identifying the objects that should be placed In-Memory for maximum benefit, along with a SQL*Plus script which implements those recommendations. It can be run on Oracle Database 18.104.22.168 and above. And of course the recommendations can be implemented on Oracle Database 22.214.171.124. (and newer).
Important to know: The In-Memory Advisor is licensed as part of the Database Tuning Pack.
Further information can be found at: OTN
In case you have obtained a pre-release version of the Advisor, please discard it and replace it with the production version