Yes, sorry. It looks like you get 1M segments when the tablespace is created
using autoallocate. I tried this on a database w/ an 8k block size and then
another w/ 2k, and both were the same.
>From: "Khedr, Waleed" <Waleed.Khedr_at_FMR.COM>
>Reply-To: ORACLE-L_at_fatcity.com
>To: Multiple recipients of list ORACLE-L <ORACLE-L_at_fatcity.com>
>Subject: RE: Locally managed tablespaces + auto-allocate
>Date: Wed, 11 Oct 2000 08:17:57 -0800
>
>It's not uniform. It's auto allocate (system managed).
>
>-----Original Message-----
>Sent: Tuesday, October 10, 2000 6:40 PM
>To: Multiple recipients of list ORACLE-L
>
>
>Your initial and next extent sizes defined for the tablespace are 1M. ->
>
>select tablespace_name, allocation_type "UNIFORM?",
> initial_extent, next_extent
>from dba_tablespaces
>where tablespace_name = 'DIMD';
>
>
> >From: "Ajay K" <ajay_at_tems.com>
> >Reply-To: ORACLE-L_at_fatcity.com
> >To: Multiple recipients of list ORACLE-L <ORACLE-L_at_fatcity.com>
> >Subject: Re: Locally managed tablespaces + auto-allocate
> >Date: Tue, 10 Oct 2000 11:55:39 -0800
> >
> >It looks like block size is small .
> >Ajay
> >
> >----- Original Message -----
> >To: "Multiple recipients of list ORACLE-L" <ORACLE-L_at_fatcity.com>
> >Sent: Tuesday, October 10, 2000 1:28 PM
> >
> >
> > > I created this table in a locally managed (auto-allocate) tablespace:
> > >
> > > create table testext ( c1 char (250)) storage (initial 10M next 10M)
> > > tablespace dimd;
> > >
> > > When I query the extents:
> > >
> > > select * from user_extents where segment_name = 'TESTEXT';
> > >
> > > SEGMENT_NA PARTITION_ SEGMENT_TYPE TABLESPACE_NAME EXTENT_ID
> >BYTES
> > > BLOCKS
> > > ---------- ---------- ------------------ --------------- ---------
> >-------
> >--
> > > ---------
> > > TESTEXT TABLE DIMD 0
> >1048576
> > > 64
> > > TESTEXT TABLE DIMD 1
> >1048576
> > > 64
> > > TESTEXT TABLE DIMD 2
> >1048576
> > > 64
> > > TESTEXT TABLE DIMD 3
> >1048576
> > > 64
> > > TESTEXT TABLE DIMD 4
> >1048576
> > > 64
> > > TESTEXT TABLE DIMD 5
> >1048576
> > > 64
> > > TESTEXT TABLE DIMD 6
> >1048576
> > > 64
> > > TESTEXT TABLE DIMD 7
> >1048576
> > > 64
> > > TESTEXT TABLE DIMD 8
> >1048576
> > > 64
> > > TESTEXT TABLE DIMD 9
> >1048576
> > > 64
> > >
> > > 10 rows selected.
> > >
> > >
> > >
> > >
> > >
> > > WHY DOES IT HAVE TO SPLIT THE EXTENT TO MANY SMALL ONES?
> > >
> > >
> > >
> > > regards
> > >
> > >
> > >
> > > Waleed
> > >
> > > --
> > > Please see the official ORACLE-L FAQ: http://www.orafaq.com
> > > --
> > > Author: Khedr, Waleed
> > > INET: Waleed.Khedr_at_FMR.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: Ajay K
> > INET: ajay_at_tems.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).
>
>_________________________________________________________________________
>Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com.
>
>Share information about yourself, create your own public profile at
>http://profiles.msn.com.
>
>--
>Please see the official ORACLE-L FAQ: http://www.orafaq.com
>--
>Author: Mike Killough
> INET: mwkillough_at_hotmail.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: Khedr, Waleed
> INET: Waleed.Khedr_at_FMR.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).
Get Your Private, Free E-mail from MSN Hotmail at
http://www.hotmail.com.
Received on Wed Oct 11 2000 - 16:32:26 CDT
