sort areas

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