"Daud" <daud11_at_hotmail.com> wrote in message
news:f0bf3cc3.0208250525.20e58680_at_posting.google.com...
> Just a simple question. Sorry if this question has been asked many
> times.
>
> In a locally managed tablespace, if I have a table that has 100
> extents allocated per day vs a table that has 1 extent allocated per
> day, does it matter? I am trying to understand if extent allocation
> has some impact on performance. My guess is yes because the extent
> allocation map or whatever you call it needs to be updated everytime
> an extent is allocated to a segment. Is the impact really that big a
> deal?
> I know the number of extents allocated to a segment does not really
> matter in a LMT tablespace.
It doesn't matter hugely, however you *do* want to avoid segments with
thousands of extents. If your segment is growing at 100 extents a day it is
a tablespace with inappropriate extent sizes. You'd want to move it to one
with extent sizes an order of magnitude or so larger. (so If its a 64k
extents size tablespace move it to one with 1m extents and so on).
--
Niall Litchfield
Oracle DBA
Audit Commission UK
*****************************************
Please include version and platform
and SQL where applicable
It makes life easier and increases the
likelihood of a good answer
******************************************
Received on Sun Aug 25 2002 - 08:39:26 CDT
