Re: Temporary Table Space Abuse

Ben,

Why should it be a lot of administration? All you need is one ALTER USER statement for each user. Maybe you can simulate automatic balancing on several disks by having several datafiles in your common temporary tablespace. But I would rather bind a tablespace "statically" to a user, making sure that all sorting goes to an intended disk.

I think that there's going to be contention if many users create tempsegs in one actual datafile.

We do use multiple temporary tablespaces, but they were created basing on theoretical assumptions, rather than because we had had problems. To All: Maybe someone else experienced contention and had to change temporary tablespace assignment?

Regards,
Karen.

Ben Ryan wrote:

> In article <37DE6278.CDB3C782_at_fmr.com>,
> Karen Abgarian <karen.abgarian_at_fmr.com> wrote:
> > In general, several temp tablespaces should be faster if they are on
> > separate disks...
>
> Do you actually use this? It would seem to require a lot of
> administration as you would have divide the users between the
> various temporary tablespaces e.g.
> ALTER USER x TEMPORARY TABLESPACE tempX;
>
> Hence there would be no automatic loading balancing. (i.e. it
> would not be balanced in the same that rollback segments are
> dynamically balanced.)
>
> >
> > Chris Forlano wrote:
> >
> > > I have about 10 tablespaces, each containing one file and averaging
> > > about 50MB.
> > > I have a single temporary tablespace containing one 500MB file.
> > >
> > > Would it be better to have separate smaller temporary tablespaces
> for
> > > each of
> > > the other tablespaces? At what point am I abusing the temporary
> > > tablespace?
> > >
> > > Running Oracle8.0.5 on Solaris2.6.
> > >
> > > Thanks,
> > >
> > > Chris
> > >
> > > --
> > > Chris Forlano
> > > TMS Project Manager
> > > Nortel Networks, Maidenhead
> > > 590 4342 (01628 434 342)
> > > cforlano_at_nortelnetworks.com
> >
> >
>
> Sent via Deja.com http://www.deja.com/
> Share what you know. Learn what you don't.
Received on Wed Sep 15 1999 - 13:21:52 CDT