An Oracle blog about Oracle Enterprise Manager and Oracle Management Cloud

  • News
    March 6, 2015

Oracle Database In-Memory Advisor

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

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


  • 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


  • 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

Stay Connected:

| YouTube
the Oracle Enterprise Manager 12c Mobile app

Be the first to comment

Comments ( 0 )
Please enter your name.Please provide a valid email address.Please enter a comment.CAPTCHA challenge response provided was incorrect. Please try again.