Optimizing Oracle Database with Solid State Disk

  • Posted on: 10 November 2011
  • By: milina.ristic
Author/Owner: 
Guy Harrison
Solid State Disk (SSD) is rapidly becoming a mainstream technology and an almost indispensable ingredient in a high performance Oracle database. While SSD is often too expensive to replace all your database disk, judicial use of SSD in combination with magnetic disk can be a very cost effective way of accelerating Oracle database performance. In this presentation we'll consider how best to use SSD in an Oracle 11g database to get the most bang for your SSD buck. We’ll see examples of configuring SSD: • as part of the 11gR2 database flash cache • to improve IO for selected tables or partitions • as part of a temporary tablespace to improve disk sort performance • to accelerate redo log IO
AttachmentSize
File Making the most of SSD in Oracle11g.pptx9.21 MB
Version: 
1
Publish Date: 
10 Nov 2011
Organization: 
Quest Software
Presenter Biography: 
Guy Harrison is an Oracle ACE and a director of Research and Development at Quest Software. Guy is the author of Oracle Performance Survival Guide (Prentice Hall, 2009) and MySQL Stored Procedure Programming (OReilly with Steven Feuerstein) as well as other books, articles and presentations on database technology. He also writes a monthly column for Database Trends and Applications (www.dbta.com). Guy can be found on the internet at www.guyharrison.net, on e-mail at guy.harrison@quest.com and is @guyharrison on twitter
field_vote: