| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> Re: extents allocation in parallel load
Tim,
Thanks for the explanation. The table I'm looking at has an initial size 32K while the new extents are all 16K. Why would this happen?
thanks
Gene
--- Tim Gorman <Tim_at_sagelogix.com> wrote:
> 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
> >
>
-- 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).Received on Tue May 14 2002 - 13:53:26 CDT
 |
 |