RE: Large in memory DW table

From: Tanel Poder <tanel.poder.003_at_mail.ee>
Date: Sat, 17 Nov 2007 11:13:10 +0800
Message-id: <0fbe01c828c7$c8a88770$3201a8c0@windows01>

Note that you'll get 3 ITL's if you load the table using direct load insert / CTAS.
--

Regards,
Tanel Poder
http://blog.tanelpoder.com <http://blog.tanelpoder.com/>

From: oracle-l-bounce_at_freelists.org [mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Nigel Thomas
Sent: Saturday, November 17, 2007 00:16
To: ric.van.dyke_at_hotsos.com; oracle-l_at_freelists.org Subject: Re: Large in memory DW table

Ric, unless things have changed recently you *always* get at least 2 slots in the ITL, even when you specify just one.

See earlier threads eg
http://www.freelists.org/archives/oracle-l/03-2005/msg00811.html.

--

http://www.freelists.org/webpage/oracle-l Received on Fri Nov 16 2007 - 21:13:10 CST