Re: problem about full scan temporary table

The space of the private copy of the temporary table is allocated in the temporary tablespace - so it is allocated one extent at a time as you need the space, and extra extents are allocated as each extent becomes full.

By default, the temporary tablespace is locally managed with uniform extents of 1MB.

Regards

Jonathan Lewis
http://www.oracle.com/technology/community/oracle_ace/ace1.html#lewis

The Co-operative Oracle Users' FAQ
http://www.jlcomp.demon.co.uk/faq/ind_faq.html

Cost Based Oracle: Fundamentals
http://www.jlcomp.demon.co.uk/cbo_book/ind_book.html

• Original Message ----- From: "qihua wu" <wqhhp_at_yahoo.com> To: <jonathan_at_jlcomp.demon.co.uk>; <oracle-l_at_freelists.org> Sent: Sunday, September 24, 2006 11:36 AM Subject: RE: problem about full scan temporary table

> Thanks for your reply, and I have a question based on
> your answer.
>
> How does oracle know certain session will insert how
> much data into the GTT?
> Suppose the session first inserts 1 row, and 10
> minutes later, inserts
> another 1,000,000 rows. So at the beginning to operate
> the GTT, how much
> space will be allocated? If the space one session
> occupied is not
> continuous, then I don't think HWM makes much sense.
>
> Thanks
> Qihua

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