Re: Locally Managed vs Dictionary managed tablespaces

From: Niall Litchfield <n-litchfield_at_audit-commission.gov.uk>
Date: Fri, 2 Nov 2001 09:10:34 -0000
Message-ID: <3be26355$0$232$ed9e5944@reading.news.pipex.net>

Actually it isn't the only reason.

Allocating and deallocating extents is moved from the data dictionary to the tablespace. This can have significant performance gains, especially for temporary tablespaces. The case is outlined well in Oracle magazine November 2000

http://www.oracle.com/oramag/oracle/00-nov/index.html?o60o8i.html

HTH

--
Niall Litchfield
Oracle DBA
Audit Commission Uk
"godmann" <allanwtham_at_yahoo.com> wrote in message
news:95cd51c.0111011844.1ae63200_at_posting.google.com...


> Niall,

>

>   So the only reason one uses LMT is to avoid fragmentation. Say I have

> third party tool to do online hot reorg, to reorg fragmented tablespace,

will


> LMT offers any benefit?

>

>

> Allan W. Tham

> DBA

Received on Fri Nov 02 2001 - 03:10:34 CST