Re: SSD on temp or undo tablespace
- From: Kevin Jernigan <kevin.jernigan@xxxxxxxxxx>
- To: mwf@xxxxxxxx
- Date: Wed, 23 May 2012 22:47:36 -0700
If you're running Oracle Database 11g Release 2 on Solaris or Oracle
Linux, you can use Database Smart Flash Cache to dynamically and
transparently extend the Oracle Database buffer cache into flash. This
will help address I/O bottlenecks in your storage array(s) without any
changes to application code, queries / reports, or data layouts on disk.
You can see more info here:
https://blogs.oracle.com/linux/entry/oracle_database_smart_flash_cache_only_on_oracle_linux_and_oracle_solaris
-Kevin J
On 5/23/12 7:27 PM, Mark W. Farnham wrote:
> 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@xxxxxxxxxxxxx [mailto:oracle-l-bounce@xxxxxxxxxxxxx]
> On Behalf Of Iotzov, Iordan
> Sent: Wednesday, May 23, 2012 1:26 PM
> To: 'oracledbaquestions@xxxxxxxxx'; oracle-l@xxxxxxxxxxxxx
> 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@xxxxxxxxxxxxx [mailto:oracle-l-bounce@xxxxxxxxxxxxx]
> On Behalf Of Dba DBA
> Sent: Wednesday, May 23, 2012 11:56 AM
> To: oracle-l@xxxxxxxxxxxxx
> 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.
>
>
> --
> //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.
> --
> //www.freelists.org/webpage/oracle-l
>
>
> --
> //www.freelists.org/webpage/oracle-l
>
>
--
//www.freelists.org/webpage/oracle-l
Other related posts:
