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 -> Re: Help: Tuning "temporary" tables

Re: Help: Tuning "temporary" tables

From: rsenn <rsenn_at_capaccess.org>
Date: 1997/12/06
Message-ID: <3489D65D.66DC70A3@capaccess.org>#1/1

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

Original text of this message

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