Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Help: Tuning "temporary" tables
How would you make the database use the 3 striped disks instead of piling all the data on the first one, leaving the other 2 empty. ( This assumes of course, that there wasn't so much data as to fill the first two stripes. )
Ron Wood wrote:
> If you can get this temporary table on striped disks, it would be your
> best
> bet. I did this using three disks, and it really made a huge
> difference.
> The dbwriters were able to get in and out much quicker, and
> performance was
> fixed almost overnight!
>
> I hope this helps,
>
> Ron Wood
>
> Gerard M. Averill <gaverill_at_chsra.wisc.edu> wrote in article
> <664h57$jq2$1_at_news.doit.wisc.edu>...
> > I've got a table which serves as a sort of stack in that it is used
by a
> > generic calculation process to store "temporary" intermediate
calculations of
> > complex "derived fields" (whose values are eventually stored
> elsewhere).
>
> > Subsequently it experiences a lot of insert and delete activity
> against
> it;
>
> >
> > Any suggestions are appreciated.
> > TIA,
> > Gerard
> >
> > ----
> > Gerard M. Averill, Associate Researcher
> > CHSRA, University of Wisconsin - Madison
> > GAverill_at_chsra.wisc.edu
> >
Received on Sat Dec 06 1997 - 00:00:00 CST