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 <[EMAIL PROTECTED]> 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" > <[EMAIL PROTECTED]> > 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: [EMAIL PROTECTED] > > > > 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: [EMAIL PROTECTED] (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: [EMAIL PROTECTED] > > 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: [EMAIL PROTECTED] (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). __________________________________________________ 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: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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).
