oracle-db-smart-flash-cache-175588

627

8页

0次

2020-02-23

10墨值下载

An Oracle White Paper

September 2010

Oracle Database Smart Flash Cache

Oracle White Paper— Oracle Database Smart Flash Cache

Introduction

Oracle Database 11g Release 2 introduced a new database feature: Database Smart

Flash Cache. This feature is available on Solaris and Oracle Enterprise Linux and allows

customers to increase the effective size of the Oracle database buffer cache without

adding more main memory to the system. For transaction-based workloads, Oracle

database blocks are normally loaded into a dedicated shared memory area in main

memory called the System Global Area (SGA). Database Smart Flash Cache allows the

database buffer cache to be expanded beyond the SGA in main memory to a second

level cache on flash memory. The Sun Storage F5100 Flash Array and the Sun Flash

Accelerator F20 PCIe Card provide a natural fit for Oracle Database Smart Flash Cache

and offer an excellent opportunity for end users to take advantage of this new

functionality.

Online Transaction Processing (OLTP) environments are expected to benefit from this

technology. It is appropriate for new Oracle Database deployments with IO-intensive

workloads as well as existing environments with main memory constraints and IO-bound

applications. Benefits can include both increased transaction throughput and improved

application response times.

Oracle Database environments with the potential to make effective use of this technology

include: workloads with repeated short transactions where many users access the same

data, storage systems that exhibit intensive disk read activity, and systems under heavy

main memory pressure that prevents more memory being allocated to the SGA buffer

cache.

This feature is expected to primarily benefit read-mostly and read-only workloads. It is

also supported in Real Application Cluster (RAC) environments – Database Smart Flash

Cache can be applied to individual RAC nodes as required.