Re: Are multiple extents still a problem with LMT?

On Apr 4, 7:24 am, "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

You may want to think about LMT with uniform extent sizes.

With 1 disk though it looks like you are just running thru an exercise in futility and there may be better things to do like fixing SQL in the application. Received on Wed Apr 04 2007 - 07:23:49 CDT