RE: SSD on temp or undo tablespace

From: Mark W. Farnham <>
Date: Wed, 23 May 2012 22:27:13 -0400
Message-ID: <004201cd3954$bbaaee30$3300ca90$>

Take care to understand that SSD covers several vintages of "flash" as well as other much faster storage technologies. I don't question Guy's numbers regarding a certain vintage of flash storage. But do not paint all SSD with that brush. Flash SSD is a kind of SSD. Not all SSD is Flash, and within the Flash category there are wide variances in write throughput.

-----Original Message-----

From: [] On Behalf Of Iotzov, Iordan
Sent: Wednesday, May 23, 2012 1:26 PM
To: ''; Subject: RE: SSD on temp or undo tablespace

You should check this white paper by Guy Harrison - zing_Oracle_RDBMS_with_Solid_State_Disk-final.pdf . It is an excellent document with lots of empirical data.

Iordan Iotzov

-----Original Message-----

From: [] On Behalf Of Dba DBA
Sent: Wednesday, May 23, 2012 11:56 AM
Subject: Re: SSD on temp or undo tablespace

does anyone use SSDs professionally? Projects with large budgets have large expenses, so you would need alot of SSDs. I would think they are still really expensive. I don't know how the professional grade SSDs compare to the professional grade hard drives in cost either. Can you plug these into a SAN?
I would think this is too expensive to use. I also don't know how much it would help given that most anything that has any kind of volume is on some kind of networked storage and that has alot of features on top of the hard drives to help with performance.


This message and its attachments may contain legally privileged or confidential information. It is intended solely for the named addressee. If you are not the addressee indicated in this message (or responsible for delivery of the message to the addressee), you may not copy or deliver this message or its attachments to anyone. Rather, you should permanently delete this message and its attachments and kindly notify the sender by reply e-mail. Any content of this message and its attachments that does not relate to the official business of News America Incorporated or its subsidiaries must be taken not to have been sent or endorsed by any of them. No warranty is made that the e-mail or attachment(s) are free from computer virus or other defect.

-- Received on Wed May 23 2012 - 21:27:13 CDT

Original text of this message