Re: sort areas

From: Matthias Gresz <GreMa_at_t-online.de>
Date: 1998/02/12
Message-ID: <6buo0m$fda$1@news00.btx.dtag.de>#1/1

On Wed, 11 Feb 1998 17:38:49 -0600, cubric_at_gcm.com.br wrote: Hi,

sort area is preallocated under NT as part of the SGA. If statistics say that to much sorts are made on disk(s) you've got to increase sort area size in your INIT<SID>.ORA, since no buffers are taken from shared pool or db-buffers.

--

Regards

Matthias Gresz    :-)

GreMa_at_T-online.de



>Does anyone know how oracle manages sort areas under MTS? Are sort areas

>pre-allocate for each user , or only when a sort is requested? Does these

>areas compete with the shared sql areas  in the shared pool? Is it

>possible that oracle moves sql out from the shared pool to make space for

>sort areas?

>

>-------------------==== Posted via Deja News ====-----------------------

>      http://www.dejanews.com/     Search, Read, Post to Usenet


--

Regards

Matthias Gresz    :-)

GreMa_at_T-online.de

Received on Thu Feb 12 1998 - 00:00:00 CST