Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> UNDO tablespace question

UNDO tablespace question

From: PuntAndPuntOften <PuntAndPuntOften_at_gmail.com>
Date: 8 Nov 2005 11:49:20 -0800
Message-ID: <1131479359.853655.163270@g14g2000cwa.googlegroups.com>


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 Received on Tue Nov 08 2005 - 13:49:20 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US