Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Are multiple extents still a problem with LMT?

Re: Are multiple extents still a problem with LMT?

From: sybrandb <sybrandb_at_gmail.com>
Date: 4 Apr 2007 04:57:35 -0700
Message-ID: <1175687855.441773.221390@b75g2000hsg.googlegroups.com>


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

Just a simple search on 'LMT' in Google provided this http://groups.google.com/group/comp.databases.oracle.server/browse_thread/thread/c0d3ffa10db754b/b99f37123e894212?lnk=gst&q=LMT&rnum=3#b99f37123e894212

--
Sybrand Bakker
Senior Oracle DBA
Received on Wed Apr 04 2007 - 06:57:35 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US