Oracle Scratchpad

October 5, 2012


Filed under: Exadata,Infrastructure,Oracle,Performance,redo — Jonathan Lewis @ 1:04 pm BST Oct 5,2012

There’s never enough time to read everything that’s worth reading, so even though Guy Harrison’s blog is one of the ones worth reading I find that it’s often months since I last read it. Visiting it late last night, I found an interesting batch of articles spread over the last year about the performance of SSD – the conclusions may not be what you expect, but make sure you read all the articles or you might end up with a completely misleading impression:

Don’t forget to read the comments as well. For other notes Guy has written about SSD, here’s a URL for his SSD tag.

1 Comment »

  1. I’m not too surprised about Guy’s conclusions about redo on SSD.
    This is not because I am expert on SSD (I can spell it) but because I attended a presentation a couple of years ago by a couple of engineers from LSI.
    Their job was to do performance testing of the new LSI SSD product for Oracle Flashcache.
    They were surprised to consistently find that redo performed better on spinning rust than on SSD.
    After discussing it with some other engineers they had a better understanding of the limitations of SSD when used with redo.
    The Powerpoint for that presentation is here:

    The most interesting redo bits aren’t available in the presention, you had to be there.
    There is mention however that due to sequential writes redo performs better on HDD.

    Comment by Jared — October 5, 2012 @ 1:47 pm BST Oct 5,2012 | Reply

RSS feed for comments on this post. TrackBack URI

Comments and related questions are welcome.

Fill in your details below or click an icon to log in: Logo

You are commenting using your account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s

This site uses Akismet to reduce spam. Learn how your comment data is processed.

Website Powered by

%d bloggers like this: