Updated version of the In-Memory Advisor is available

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

Leave a Reply

Your email address will not be published. Required fields are marked *