Wednesday May 07, 2014

Make Your Database Run Faster on Oracle Linux

If you can get your hands on a Sun Flash Accelerator F40 PCIe Card, and you're running Oracle Database 11g Release 2 or later on Oracle Linux, you can use the Oracle Database Smart Flash Cache to improve performance and response times. That was a mouthful, so let me say it again.

  1. Configure Sun Flash Accelerator F40 PCIe Card as a file system.
  2. Configure Oracle Automatic Storage Management, a feature of Oracle Database, to use multiple Sun Flash Accelerator F40 PCIe Cards.
  3. Configure the Database Smart Flash Cache capability of Oracle Database.

Your pals at Jay Leno's garage can keep a 27-liter 1930 Bentley humming, but they can't help you with that little procedure can they? No worries, Rick Stenho may not own a Bentley, but he can help your database run faster.

Tech Article: How to Improve Database Performance Using Database Smart Flash Cache on Oracle Linux

by Rick Stenho

Oracle Database 11g Release 2 Enterprise Edition allows you to use flash devices to increase the effective size of the Oracle Database buffer cache (Level 2 cache) without adding more main memory. This capability is referred to as Database Smart Flash Cache. This article walks you through the steps required to take advantage of it.

Caution: Any performance advantages you obtain with smart flash cache will probably be nullified by the time you waste watching Jay Leno's garage.

About the Photograph

Photograph of lamp at the Venetian and Sands Expo Center
in Las Vegas taken by Rick Ramsey during Collaborate 2014

- Rick
Follow Rick on:
Personal Blog | Personal Twitter
  Follow OTN on:
Web | Facebook | Twitter | YouTube
About

Contributors:
Rick Ramsey
Kemer Thomson
and members of the OTN community

Search

Archives
« March 2015
SunMonTueWedThuFriSat
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
    
       
Today
Blogs We Like