Oracle In-Memory Advisor now available

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 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

In case you have obtained a pre-release version of the Advisor, please discard it and replace it with the production version

–Mike

2 thoughts on “Oracle In-Memory Advisor now available

  1. Hi Mike,

    we are having diagnostic and tuning pack. we don’t have in memory option. can i still use this advisor to check which tables we can use for in-memory option if we take.

    Thanks and Regards,
    lpathi

Leave a Reply

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