temporary temp vs permanent temp

From: G.Ong <onggs_at_acslink.aone.net.au>
Date: Mon, 21 Jan 2002 22:32:45 +1100
Message-ID: <FPS28.6783$N31.292102@ozemail.com.au>

Hi,

Our system is 8.1.6.3 on Solaris 2.7.

We used to used to have temporary segments on temporary tablespace (ie those created : create tablespace xxx temporary ). However, because of a number of unable to extend temporary segments, the system DBA recommend using temporary segments on permanent tablespace (because the sort segments are immediately released).

Questions:
1) Is this a valid decision ?
2) If a hash join occurred involving a large table, does it use the same sort segment created for sorts ? (In this case, assuming a temporary temp is used.)

TIA,
Ghee Received on Mon Jan 21 2002 - 05:32:45 CST