I was hoping to see "*" column values from DBA_TABLESPACES, not just the "default storage" column values. This would show whether the tablespace in question was locally-managed (and SYSTEM or UNIFORM, if so) as well...
You don't need to include the temporary tablespace -- it's not relevant. TEMPORARY segments can be created in any tablespace, especially during direct-path operations... ----- Original Message ----- To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]> Sent: Tuesday, May 14, 2002 3:18 PM > Tim, > > SQL> select TABLESPACE_NAME, INITIAL_EXTENT/1024, > NEXT_EXTENT/1024, PCT_INCREASE > 2 from dba_tablespaces > 3 where tablespace_name like 'TEMP%' > 4 or tablespace_name = 'TREPD01'; > > TABLESPACE_NAME INITIAL_EXTENT/1024 > NEXT_EXTENT/1024 PCT_INCREASE > ------------------------------ ------------------- > ---------------- ------------ > TREPD01 40 > 40 0 > TEMP01 1024 > 1024 0 > > TREPD01 is where the tables are located, TTEMP01 is > the temp tablespace. > > Gene > --- Tim Gorman <[EMAIL PROTECTED]> wrote: > > What does "SELECT * FROM DBA_TABLESPACES" show for > > the tablespace involved? > > > > ----- Original Message ----- > > To: "Multiple recipients of list ORACLE-L" > > <[EMAIL PROTECTED]> > > Sent: Tuesday, May 14, 2002 12:53 PM > > > > > > > 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). > > > > -- > > 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). -- 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).
