Path: news.f.de.plusline.net!news-fra1.dfn.de!news-lei1.dfn.de!newsfeed.freenet.de!news2.euro.net!nx02.iad01.newshosting.com!newshosting.com!198.186.194.247.MISMATCH!news-out.readnews.com!news-xxxfer.readnews.com!postnews.google.com!y80g2000hsf.googlegroups.com!not-for-mail From: "Andy Kent" Newsgroups: comp.databases.oracle.server Subject: Are multiple extents still a problem with LMT? Date: 4 Apr 2007 04:24:30 -0700 Organization: http://groups.google.com Lines: 14 Message-ID: <1175685870.650528.217830@y80g2000hsf.googlegroups.com> NNTP-Posting-Host: 193.128.17.98 Mime-Version: 1.0 Content-Type: text/plain; charset="iso-8859-1" X-Trace: posting.google.com 1175685877 25877 127.0.0.1 (4 Apr 2007 11:24:37 GMT) X-Complaints-To: groups-abuse@google.com NNTP-Posting-Date: Wed, 4 Apr 2007 11:24:37 +0000 (UTC) User-Agent: G2/1.0 X-HTTP-UserAgent: Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.1; SV1; .NET CLR 1.1.4322),gzip(gfe),gzip(gfe) Complaints-To: groups-abuse@google.com Injection-Info: y80g2000hsf.googlegroups.com; posting-host=193.128.17.98; posting-account=HD0nyw0AAAATtsf2lXti_t8jTa7jr7GW Xref: news.f.de.plusline.net comp.databases.oracle.server:195725 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