Re: temporary tablespaces

From: Chuck <chuckh_at_softhome.net>
Date: 12 Sep 2003 18:34:02 GMT
Message-ID: <Xns93F4942F429D2chuckhsofthomenet@130.133.1.4>

"Sybrand Bakker" <postbus_at_sybrandb.nospam.demon.nl> wrote in news:vm3vv8duaeofeb_at_corp.supernews.com:

>
> "David COSTE" <dco_at_compaq.com> wrote in message
> news:Onl8b.4630$je2.2848_at_news.cpqcorp.net...

>> It's because my batch processing consumes temporary segments and I
>> don't want to see it run out of space because some one would have
>> launched a big query with an order by.
>>  The idea is to avoid sharing the same temp tablespace for the 2

> activities.

>>
>>

> This is not going to help you at all. If you set up 2 different
> tablespaces for 2 different users/processes, those processes will
> still be capable to have your temp tablespaces out of space.
> Make sure you have adequate space, as disk is cheap, and stop symptom
> fighting.
>
>

Huh? If two users are using two completely different temporary tablespaces, how does one cause the other to run out of space? Of course I assuming that you do *NOT* have autoextend enabled on the tempfiles. Received on Fri Sep 12 2003 - 13:34:02 CDT