Skip to main content

Techdocs Library > Presentations & Tools >

Improving Analytics: Experiences Testing Oracle Database 12c In-Memory Feature



Document Author:
Additional Author(s):

Ralf Schmidt-Dannert
Wayne T Martin


Document ID:

PRS5344


Doc. Organization:

BI/ERP Solutions Center


Document Revised:

06/13/2016


Product(s) covered:

Oracle RAC; Oracle Database; Oracle RDBMS; POWER8







Abstract: This session starts with a brief overview of Oracle 12c Database In-Memory, and then we'll share our experiences testing this feature with simple and complex queries, multiple schemas, and large memory. We have run time comparisons to share for a set of reporting queries run In-Memory compared to disk row format, as well as hints and tips for getting the best results with In-Memory. We will also show data points for loading data into memory including the use of compression, benefits seen using Vector Transformation execution plans, and even a comparison between In-Memory and using database buffer keep cache (In-Memory is an order of magnitude better while using less memory). This presentation can be shared with IBM customers.

Oracle_InMemory_On_Power_OVU_v1.6.pdfOracle_InMemory_On_Power_OVU_v1.6.pdf
Improving Analytics Experiences Testing Oracle Database 12c In-Memory Feature .mov



Classification:

Solutions

Category:

Planning and Design

Solution(s):

ISV Applications

ISV(s):

Oracle

Platform(s):

IBM Power Systems



O/S:

AIX

Keywords:

IBM Power Systems, AIX, Oracle Database 12c, In-Memory, RAC Vector Transformation


The Techdocs Library
Is this your first visit to Techdocs (the Technical Sales Library)?

Learn more


Techdocs QuickSearch

: