Oracle Enterprise Manager: Oracle Database In-Memory Advisor

By Scott Mcneil-Oracle on Mar 06, 2015

Recently, Oracle announced the general availability of the Oracle Database In-Memory Advisor—a new capability built into Oracle Enterprise Manager 12c Tuning Pack. With this release, Oracle introduces new and extensive capabilities for managing Oracle Database In-Memory, an Oracle Database 12c Enterprise Edition option. Oracle Database In-Memory can be used to improve queries on a variety of OLTP and/or data warehouse operations. The In-Memory Advisor helps to optimize performance with recommendations to run analytics processing faster. It gives customers insight into the sizing of the workload and offers actionable recommendations for running workloads at peak performance. The Advisor analyzes workloads and related objects making specific recommendations to which objects would give you the greatest benefit and performance if they were placed In-Memory . Key Capabilities: Assists with In-Memory size selection Recommendations for tables, partitions and sub-partitions for a given In-Memory size Uses workload and performance data to prioritize objects Takes into account differences in disk and memory footprint, as well as compression ratios Actionable Recommendations Workload based cost/benefit analysis Cost: Offers estimated memory size with various compression options Benefit: Offers estimated database time reduction metrics for workload processing In-memory area population plan Reporting Ability to vary In-Memory size to receive specific loading plan Generates DDL scripts with all the tables/partitions/sub-partitions recommended Top SQL benefits from any given configuration For more information, visit the Oracle Database In-Memory Advisor page on the Oracle Technology Network. You can download the In-Memory Advisor, via MOS note 1965343.1.