Re: index creation fails because temp tablespace is too small

From: Sybrand Bakker <postbus_at_sybrandb.demon.nl>
Date: Wed, 27 Apr 2005 22:47:59 +0200
Message-ID: <7huv615c4sd7cfve2sufh5r6k0camvlgct@4ax.com>

On 27 Apr 2005 12:43:51 -0700, "Dutch_alien" <arian_at_bearen.demon.nl> wrote:

>Most of all, it made me wonder how sort_area_size is related to it.
>(Background: One of my customers is using W2K, and we keep running into
>the 2/3Gb memory limit).

sort_area_size is related in such a way: as soon as your sort exceeds sort_area_size, you will hit the temporary segment. It is pretty daft to set sort_area_size to 2 or 3 G, especially as this is a *per sort limit* , *NOT* a *system wide limit*.

--
Sybrand Bakker, Senior Oracle DBA

Received on Wed Apr 27 2005 - 15:47:59 CDT