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

Things I don't like about it.

1. It's end of life and the manufacturer is recommending other products from a different product line.
2. I really don't like the idea of a san disk expiring after x I/O operations - I don't know how many i/os my disks have been subjected to, or are subjected to on a regular basis, and what the variation is. I've not yet met anyone who does either - though I have a sneaking suspicion that I might know at least one person who does keep this info.

then there's the broader question as to whether

1. you are IO bound and
2. the IO that is binding you is optimised.

Of course redo IO is optimised and often is a significant drain so SSD devices might be approprate there.
Niall
On Jan 6, 2008 9:34 PM, Jurijs Velikanovs <j.velikanovs_at_gmail.com> wrote:

> Hello everyone and Happy new year to you,
>
> Just wonder if you can give your advice if the devices as following
> will make any difference in the context for Oracle RDBMS performance
> in the nearest time?
>
> http://www.sandisk.com/OEM/ProductCatalog(1331)-SSD_Ultra320_Wide_SCSI_35.aspx
>
> From my point of view:
> - "Access time <0.02 ms" at least 30 times faster then today's HDD-s
> capable to achieve.It gives significant improvement for some profile
> Physical IO-s.
> - Current price 5k for 300GB might be acceptable for some systems even
> today. This parameter will go down within 1-2 years significantly.
> - Max read/write operation count is limited. In spite of that to use
> first point some organizations might choose to change HDD on regular
> basis (once a year/months) to improve throughput for some applications
> - It will not solve all problems but introduce significant
> improvements in some areas.
>
> PS I am sorry if this topic has been discussed already, please point
> me to the thread then.
>
> Thank you in advance,
> Jurijs
> --
> http://www.freelists.org/webpage/oracle-l
>
>
>

-- 
Niall Litchfield
Oracle DBA
http://www.orawin.info

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