Re: Are multiple extents still a problem with LMT?

On 4 abr, 13:24, "Andy Kent" <andykent.bristol1..._at_virgin.net> wrote:
> I'm going to migrate the tablespaces of an old 8i/w2k database I've
> inherited from DMT to LMT as a first shot in addressing seriously
> degraded performance in queries that have to go to disk.
>
> I need to decide whether to allow for table rebuilding in the downtime
> I ask for. The whole database is under a Gig but everything has been
> created with 64k blocks and a couple of tables have run to several
> thousand extents. Will LMT eliminate most of the effects of extent
> fragmentation or are undersized table extents going to create a
> similar performance hit? The box only has the one disk so things are
> always going to be messy to some degree.
>
> Andy

"The whole database is under a Gig but everything has been created with 64k blocks"

You mean 'extents' don't you?

Cheers.

Carlos. Received on Wed Apr 04 2007 - 06:48:15 CDT