Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Are multiple extents still a problem with LMT?
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 DBAReceived on Wed Apr 04 2007 - 06:57:35 CDT