Make Your Database Run Faster on Oracle Linux
By RickRamsey-Oracle on May 07, 2014
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.
- Configure Sun Flash Accelerator F40 PCIe Card as a file system.
- Configure Oracle Automatic Storage Management, a feature of Oracle Database, to use multiple Sun Flash Accelerator F40 PCIe Cards.
- 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.
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|