Re: exhausting temp space

From: DA Morgan <damorgan_at_exesolutions.com>
Date: Wed, 08 Jan 2003 13:24:20 -0800
Message-ID: <3E1C9704.7E6838B0@exesolutions.com>

michael ngong wrote:

> I am trying to simulate a problem that seemingly comes up when the
> temporary tablespace is completely used up (free space 0).Should this
> have any impact on users connecting through three tier even if they
> are not running jobs?
>
> Database specifics
> next_extent is 131072.
> Oracle version 8.1.7.2.0
> OS HP 11.0
> Application Peoplesoft
>
> Ideally I am trying to come up with a generic query which should be
> able to function on any system e.g complex queries on the the data
> dictionary views.
> TIA
> Michael Ngong

Yes!

If you want to test do it on a DEV or TEST box. And you can do it by creating a new user and a second temporary tablespace and assigning that new temp tablespace to only the single user doing the testing.

Daniel Morgan Received on Wed Jan 08 2003 - 15:24:20 CST