Message-Id: <10568.112761@fatcity.com> From: "Madhavan Amruthur" Date: Mon, 24 Jul 2000 09:08:53 PDT Subject: Re: Extent size of locally managed tablespaces Yes, Jared its becoming difficult to type in locally managed tablespaces :-) Chuck - The 64K needs to be allocated when the datafile is created. For eg: if you decide to have the datafile size as 500M which is 512000K then add 64K to this size and 512064K is the size you need for the datafile. If you do not add that 64K and if you specify uniform size to be 50M then u will get 9 extents for 450M and 1 50M extent will be used for the bitmap though it needs only 64K. so make the datafile size an exact multiple of the uniform size and add 64K to that size. create tablespace test datafile 'name' size 512064K extent management local uniform size 50M will give you 10 extents of 50M each and 64K for the bitmap create tablespace test datafile 'name' size 512000K extent management local uniform size 50M will create 9 50M extents and use 1 50M extent for the bitmap Hope this helps. Regards, Madhavan IBM Corporation >From: Chuck Hamilton >Reply-To: ORACLE-L@fatcity.com >To: Multiple recipients of list ORACLE-L >Subject: Re: Extent size of locally managed tablespaces >Date: Mon, 24 Jul 2000 07:36:54 -0800 > > > So where can you set the size of the LMT bitmap? It always uses the >extend size when I create one. > > Jared Still wrote: >On Thu, 20 Jul 2000, Madhavan Amruthur wrote: > > > The bitmap for LMT's need only 64K. > >LMT's? First time I've seen that. > >Thanks Madhaven for yet another acronym. > >( That's YAA to you ;) > > >Jared Still >Certified Oracle DBA and Part Time Perl Evangelist ;-) >Regence BlueCross BlueShield of Oregon >jkstill@bcbso.com - Work - preferred address >jkstill@teleport.com - private > > >-- >Author: Jared Still >INET: jkstill@bcbso.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@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). > > >--------------------------------- >Do You Yahoo!? >Get Yahoo! Mail - Free email you can access from anywhere! ________________________________________________________________________