Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> Extent size of locally managed tablespaces

Extent size of locally managed tablespaces

From: Chuck Hamilton <chuck_hamilton_at_yahoo.com>
Date: Thu, 20 Jul 2000 07:32:56 -0700 (PDT)
Message-Id: <10564.112536@fatcity.com>


--0-1189641421-964103576=:11881

Content-Type: text/plain; charset=us-ascii

I want to set up a locally managed tablespace that allocates data in 50m chunks. When I create it with "extent management local uniform size 50m" however, the first extent is allocated (for the bitmap?) at 50m. That's a lot of space to waste on a bitmap. Is there some way to reduce the bitmap size and still keep the extents large?



Do You Yahoo!?
Get Yahoo! Mail - Free email you can access from anywhere!
--0-1189641421-964103576=:11881

Content-Type: text/html; charset=us-ascii

<P>I want to set up a locally managed tablespace that allocates data in 50m chunks. When I create it with "extent management local uniform size 50m" however, the first extent is allocated (for the bitmap?) at 50m. That's a lot of space to waste on a bitmap. Is there some way to reduce the bitmap size and still keep the extents large?</P><BR><BR><p><br><hr size=1><b>Do You Yahoo!?</b><br> Get Yahoo! Mail - Free email you can access from anywhere!
--0-1189641421-964103576=:11881--
Received on Thu Jul 20 2000 - 09:32:56 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US