Re: UNDO tablespace question

On 8 Nov 2005 11:49:20 -0800, "PuntAndPuntOften" <PuntAndPuntOften_at_gmail.com> 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

The best solution of course is
- tume the app
- tune the app
and
- (did I say) tune the app
or, better still, just ditch it, and start all over again, now doing things properly.

Remember also usually the datafile is the smallest point of failure and recovery, and depending on O/S (why are people so lazy to avoid to specify version info) a 5 G datafile can be a problem.

--
Sybrand Bakker, Senior Oracle DBA