Re: Flash for TEMP
From: Rich Jesse <rjoralist_at_society.servebeer.com>
Date: Thu, 20 May 2010 15:37:25 -0500 (CDT)
Message-ID: <4c39aa1dc32a06157e98ef18bbf4496c.squirrel_at_society.servebeer.com>
Hey Kellyn,
Date: Thu, 20 May 2010 15:37:25 -0500 (CDT)
Message-ID: <4c39aa1dc32a06157e98ef18bbf4496c.squirrel_at_society.servebeer.com>
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
-- http://www.freelists.org/webpage/oracle-lReceived on Thu May 20 2010 - 15:37:25 CDT