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
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
Ipathi,
yes, Tuning Pack is enough to test with the in-mem advisor. No need at this stage to license the in-mem option.
Cheers
Mike