RE: Large in memory DW table
- From: Tanel Poder <tanel.poder.003@xxxxxxx>
- To: nigel_cl_thomas@xxxxxxxxx, ric.van.dyke@xxxxxxxxxx, oracle-l@xxxxxxxxxxxxx
- Date: Sat, 17 Nov 2007 11:13:10 +0800
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@xxxxxxxxxxxxx [mailto:oracle-l-bounce@xxxxxxxxxxxxx]
On Behalf Of Nigel Thomas
Sent: Saturday, November 17, 2007 00:16
To: ric.van.dyke@xxxxxxxxxx; oracle-l@xxxxxxxxxxxxx
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
//www.freelists.org/archives/oracle-l/03-2005/msg00811.html.
Other related posts:
