Which of your tables and/or partitions should you mark for In-Memory column store availability?
You’ll get the answer with the help of the Oracle In-.Memory Advisor which just got updated and is available via 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 11.2.0.3 and above. And of course the recommendations can be implemented on Oracle Database 12.1.0.2. (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
The New Features include:
- Oracle Multitenant support
- Enhanced analysis
- and bug fixes
See the RELEASE NOTES for further details on version 1.0.0.1.
–Mike