RE: problem about full scan temporary table

Hi,  

Temporary tablespace space is managed differently than normal tablespaces. They use some in-memory maps for that, thus allocating new extents shouldn't be much of an overhead.  

Tanel.

From: oracle-l-bounce_at_freelists.org [mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Binh Pham
Sent: Sunday, September 24, 2006 23:18
To: jonathan_at_jlcomp.demon.co.uk; wqhhp_at_yahoo.com; oracle-l_at_freelists.org Subject: Re: problem about full scan temporary table

Jonathan,

If someone wants to load lots of data into the GTT, based on the 1M extent size, doesn't this seem to be inefficient and may pose a performance issue due to Oracle has to keep extending? I guess that if one wants to load lots of data (i.e. 1G+ data) into GTT, there might be other options rather than GTT.

--
http://www.freelists.org/webpage/oracle-l