了解何时使用Oracle数据库内存选件-WhentoUseOracle.PDFVIP

When to Use Oracle Database In-Memory Identifying Use Cases for Application Acceleration O R A C L E W H I T E P A P E R | M A R C H 2 0 1 5 Executive Overview Oracle Database In-Memory is an unprecedented breakthrough in Oracle database performance, offering incredible performance gains for a wide range of workloads. Oracle Database In-Memory can provide orders of magnitude performance improvements for analytics workloads, as well as substantial improvements for mixed-workload Enterprise OLTP applications. This document briefly introduces Database In-Memory, enumerates high-level use cases, and explains the scenarios under which it provides a performance benefit. The purpose of this document is to give you some general guidelines so that you can determine whether your use case is a good match for this exciting new technology. Introducing Database In-Memory Database In-Memory features a highly optimized In-Memory Column Store (IM column store) maintained alongside the existing row formatted buffer cache as depicted below in Figure 1. The primary purpose of the IM column store is to accelerate column-oriented data accesses made by analytics operations. It is similar in spirit to having a conventional index (for analytics) on every column in a table. However, it is much more lightweight than a conventional index, requiring no logging, or any writes to the database. Just as the performance benefit to an application from conventional indexes depends on the amount of time the application spends accessing data in the tables that are indexed, the benefit from the IM column store also depends on the amount of time the application spends on data access for analytic operations. It is therefore important to understand the basic characteristics of your application in order to determine the potential benefits from Database In-Memory. Figure 1: Dual format in-memory representation featuring new in-memory column store How Does Database In-Memory Improve Pe