RE: SSD on temp or undo tablespace
Date: Wed, 23 May 2012 22:27:13 -0400
Message-ID: <004201cd3954$bbaaee30$3300ca90$_at_rsiz.com>
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: oracle-l-bounce_at_freelists.org [mailto:oracle-l-bounce_at_freelists.org]
On Behalf Of Iotzov, Iordan
Sent: Wednesday, May 23, 2012 1:26 PM
To: 'oracledbaquestions_at_gmail.com'; oracle-l_at_freelists.org
Subject: RE: SSD on temp or undo tablespace
You should check this white paper by Guy Harrison - http://www.quest.com/Quest_Site_Assets/WhitePapers/Best_Practices_for_Optimi zing_Oracle_RDBMS_with_Solid_State_Disk-final.pdf . It is an excellent document with lots of empirical data.
Iordan Iotzov
http://iiotzov.wordpress.com/
-----Original Message-----
From: oracle-l-bounce_at_freelists.org [mailto:oracle-l-bounce_at_freelists.org]
On Behalf Of Dba DBA
Sent: Wednesday, May 23, 2012 11:56 AM
To: oracle-l_at_freelists.org
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.
--
http://www.freelists.org/webpage/oracle-l
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.
--
http://www.freelists.org/webpage/oracle-l
--
http://www.freelists.org/webpage/oracle-l
Received on Wed May 23 2012 - 21:27:13 CDT