RE: Flash for TEMP

That is the most you can save on the temp i/o. But there is also the side
effect of lightening the load on the rest of the disk farm. So you may
reduce both temp i/o time and some fraction of the other i/o time. In my
various writings this is what I mean by "de-heat the disk farm." If heavy
temp writing is responsible for cache pollution on your array this can be
quite significant. For example if things that might have been re-read from
the SAN cache are being driven out by the temp i/o, that could be pretty
big. And if the SSD is accessed by a different channel than the SAN and your
current SAN bottleneck is i/o adapters that could also play a role. But as
Martin wrote, your maximum acceleration is gated by the time you currently
spend in i/o.

By the way, you mention Flash specifically in your headline and then the
more general SSD in the body of your text. There remain other kinds of SSD
than Flash. Your mileage on best use, price/performance ratios, and speed
may vary.

Regards,

mwf

-----Original Message-----
From: oracle-l-bounce@xxxxxxxxxxxxx [mailto:oracle-l-bounce@xxxxxxxxxxxxx]
On Behalf Of Martin Berger
Sent: Wednesday, May 19, 2010 3:47 PM
To: jhthomp@xxxxxxxxx
Cc: oracle-l@xxxxxxxxxxxxx
Subject: Re: Flash for TEMP

How much time spends your Application in IOs on the TempTS?
That's the maximum boost you can gain.

Martin

Am 19.05.2010 um 19:03 schrieb John Thompson:

> Anyone see any issues using an SSD mounted as a file system and used  
> for the temporary tablespace?  We have an application that uses  
> temporary tables extensively, and I'm hoping to get a performance  
> boost.

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




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

Other related posts: