Re: Oversized TEMP space

From: Paul Drake <bdbafh_at_gmail.com>
Date: Tue, 21 Jun 2005 12:10:11 -0400
Message-ID: <910046b40506210910461649c1@mail.gmail.com>

On 6/21/05, Barr, Stephen <Stephen.Barr_at_bskyb.com> wrote:

> Are there any possible issues with oversizing a TEMP tablespace?
>
> Would it affect any of the costing algorithms?
>
> Are there any other downsides other than the small management overhead?

Actually, I can see something positive out of this:

The SA won't see all that unused space on the storage volume. The CTO can think that his disk utilization % is high. The DBA can drop the temp tablespace and reuse the space when its needed. The heinous cartesian join run by the adhoc user doesn't puke until it hits the platform limit.

Everybody wins. :)

create temporary tablespace bogus ...

Paul

--
http://www.freelists.org/webpage/oracle-l

Received on Tue Jun 21 2005 - 12:15:25 CDT