Re: UNDO tablespace question

PuntAndPuntOften wrote:
> Hello,
>
> I want to configure my very active 20 gig UNDO tablespace across 4
> disks. I want to balance the IO as much possible, using the most
> efficient layout. I'm trying to determine it it would be better to
> create 20 each 1 gig data files and assign them round-robin to the UNDO
> tablespace, or is it better to create 4 each 5 gig datafiles.
>
> Any and all feedback appreciated (intelligent guesses included).
>
> PuntAndPuntOften

How about one 20 Gig datafile striped across all 4 disks?

I'm with Sybrand ... tune the app.

-- 
Daniel A. Morgan
http://www.psoug.org
damorgan_at_x.washington.edu
(replace x with u to respond)