Re: sort areas

From: Kevin Riibe <kriibe5_at_pdq.net>
Date: 1998/02/11
Message-ID: <6btre9$4nv$1@usenet49.supernews.com>#1/1

Sort area is not in the shared pool -- rather there is a separate area /per thread/ that is allocated (defined in the INIT.ORA). I believe MTS wrks the same as dedicated processes -- whenever sort process is required -- Oracle will allocate the appropriate memory. Course, if the sort criteria exceeds memory -- you get to go to the TEMP tablespace (make sure you use "temporary" temporary tablespaces)...

Kevin.
kevin.riibe_at_compaq.com

cubric_at_gcm.com.br wrote in message <887239759.1378418690_at_dejanews.com>...
>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
Received on Wed Feb 11 1998 - 00:00:00 CST