Re: Flash technology based HDD will it make significant difference for OLTP applications?

See thread http://www.freelists.org/archives/oracle-l/09-2005/msg01024.html including pertinent comments from Cary Milsap, Kevin Closson, Nuno Souto and many more ...

And this more recent post from Kevin's Manly Men series: http://kevinclosson.wordpress.com/2007/07/21/manly-men-only-use-solid-state-disk-for-redo-logging-lgwr-io-is-simple-but-not-lgwr-processing/

An obvious disadvantage of a solid state disc is that it pretends to be a disc (ie it's an inefficient way of accessing what is effectively memory). You have to go through the I/O driver (and the cable - SCSI or what you will) before you actually get the data back. These mechanisms have been designed in the confident expectation that the turnaround time will be multiple milliseconds. Rather like going to the corner shop for a tin of beans rather than looking in the kitchen cupboard, methinks...

Regards Nigel

--
http://www.freelists.org/webpage/oracle-l