HiveBrain v1.2.0
Get Started
← Back to all entries
patternMinor

SSDs with Oracle

Submitted by: @import:stackexchange-dba··
0
Viewed 0 times
withoraclessds

Problem

We've been looking into using SSDs with Oracle to speed up our test migration runs. It currently takes 12-18 hours to complete a migration run, depnding on the volume of data (we're obviously doing lots of performance tweaking too). We've a number of cheap linux boxes we're using for various runs and analysis.

The cost of SSDs direct from Dell is prohibitive. I was wondering if anyone has experience of using consumer SSDs (such as the Crucial/Micron ones).

I realise TRIM support would be an issue on Linux (using Centos). Has anyone used them on Windows 7 to counter this?

Solution

I don't see any answers to your question yet, and while I don't have any experience with using consumer grade SSD drives with a database, I thought the following question on ServerFault might be useful:

https://serverfault.com/questions/69037/configuring-sql-for-optimal-performance-ssd-or-hdd

edit: I found the following article recently and thought I'd add it to my answer. It talks about using SSDs with SQL Server, but I thought some of the factors discussed might be useful for Oracle DBAs as well.

http://technet.microsoft.com/en-us/magazine/hh334997.aspx (Reduce I/O, Increase Performance)

Context

StackExchange Database Administrators Q#573, answer score: 7

Revisions (0)

No revisions yet.