Re: Flash for TEMP

  • From: "Rich Jesse" <rjoralist@xxxxxxxxxxxxxxxxxxxxx>
  • To: oracle-l@xxxxxxxxxxxxx
  • Date: Thu, 20 May 2010 15:37:25 -0500 (CDT)

Hey Kellyn,

> Because I'm able to
> stripe across the tempfiles in each of the temp tablespaces instead of one
> tempfile sequentially, we saw the following improvements

How exactly are you using groups to stripe?  The only thing I can think of
is PQ, although I have yet to test it.  MOS 245645.1 and my own quick
single-threaded test indicate that only one TS is a group is used by any one
process.

Thanks!

Rich

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


Other related posts: