Re: extents allocation in parallel load

SQL*Loader in direct-parallel mode (i.e. DIRECT=TRUE, PARALLEL=TRUE) first loads into a TEMPORARY segment. After the load completes, then the TEMPORARY segment is "merged" with the table segment. All of the "direct" (a.k.a. "append") operations work this way when executed in parallel (i.e. INSERT /*+ APPEND PARALLEL */, CREATE INDEX ... PARALLEL, CREATE TABLE ... PARALLEL ... AS SELECT, etc)...

Only SQL*Loader's direct-nonparallel mode (i.e. DIRECT=TRUE, PARALLEL=FALSE) loads into space on the table segment above the current "high-water mark". That expected scenario is probably the reason why you expect all new extents to be sized according to NEXT...

So, the newly added extents were probably "INITIAL" extents for the original TEMPORARY segments, before they were merged into the table segment, perhaps?

• Original Message ----- To: "Multiple recipients of list ORACLE-L" <ORACLE-L_at_fatcity.com> Sent: Tuesday, May 14, 2002 10:33 AM

> Hi,
>
> I'm confused by the way some of my extents are
> allocated in Oracle. I've talked to Oracle reps, I
> thing I've posted here before and jsut when I thought
> I got an understanring - ooops, everything is gone. So
> I'll give it another try. I have a table with initial
> set to 32K and next set to 1M. This table is being
> loaded on a daily basis via Ab initio. The load is
> done by SQL*loader in direct mode in parallel (I
> believe it is 8 ways). Now all the segments that have
> been created for this table (besides the 1st one) are
> 16K. Where does this size come from? I thought it
> should use the NEXT parameter for the new extents, but
> it doesn't. Can someone give me some pointers?
>
> thanks
>
> Gene
>
> __________________________________________________
> Do You Yahoo!?
> LAUNCH - Your Yahoo! Music Experience
> http://launch.yahoo.com
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: Gurelei
> INET: gurelei_at_yahoo.com
>
> Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
> San Diego, California -- Public Internet access / Mailing Lists
> --------------------------------------------------------------------
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from). You may
> also send the HELP command for other information (like subscribing).

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Tim Gorman
  INET: Tim_at_SageLogix.com

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).