Re: number of extents question

From: Richard Foote <richard.foote_at_bigpond.com>
Date: Thu, 12 Sep 2002 17:08:25 +1000
Message-ID: <kWWf9.30158$g9.86938@newsfeeds.bigpond.com>

Hi Jan,

Note that this article doesn't cover locally managed tablespaces. The basic principles still apply to some degree but I would strongly recommend the use of LMT with appropriately configured Uniform sizes.

Cheers

Richard
"Jan Gelbrich" <j_gelbrich_at_westfalen-blatt.de> wrote in message news:alni6g$1rboct$1_at_ID-152732.news.dfncis.de...
> Thank You *very much*, Pablo, for this post. The document goes to option
2,
> but
> I never found something comparable in details. Wow!
>
> Jan=)
>
> "Pablo Sanchez" <pablo_at_dev.null> schrieb im Newsbeitrag
> news:Xns928591663716Epingottpingottbah_at_192.168.1.1...
> > "Jan Gelbrich" <j_gelbrich_at_westfalen-blatt.de> wrote in
> > news:alli1a$1ppeaj$1_at_ID-152732.news.dfncis.de:
> >
> > > Does it or does it not matter (that is: decreasing my performance)
> > > having 1, 10 or 200 extents for one index segment (and BTW, same
> > > question for tables) ?
> >
> > I think the best write-up I found on this was done by some folks at
> > Oracle. A quick google search found it at the following site:
> >
> > http://www.dbatoolbox.com/WP2001/spacemgmt/defrag.htm
> >
> > It's a good read.
> > --
> > Pablo Sanchez, High-Performance Database Engineering
> > http://www.hpdbe.com
>
>
Received on Thu Sep 12 2002 - 02:08:25 CDT