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

Home -> Community -> Mailing Lists -> Oracle-L -> RE: LOCALLY MANAGED TABLESPACE

RE: LOCALLY MANAGED TABLESPACE

From: Deshpande, Kirti <kirti.deshpande_at_verizon.com>
Date: Fri, 25 Oct 2002 06:28:34 -0800
Message-ID: <F001.004F3A05.20021025062834@fatcity.com>


In a 'converted/migrated' LMT, tables/indexes can not take advantage of UNIFORM or SYSTEM (autoallocate) policy of extent management. Those objects still grow with their old 'next' extent sizes. For full benefits of LMT, consider creating new LMT tablespaces and moving objects to them. Search Metalink. There are a number of documents/notes on converting DMT to LMT.  

-----Original Message-----

Sent: Friday, October 25, 2002 8:04 AM
To: Multiple recipients of list ORACLE-L

The only issue we faced was convincing the management that in LMT having 150 extents is not really a problem.

Raj



Rajendra Jamadagni MIS, ESPN Inc. Rajendra dot Jamadagni at ESPN dot com
Any opinion expressed here is personal and doesn't reflect that of ESPN Inc.

QOTD: Any clod can have facts, but having an opinion is an art!

-----Original Message-----

Sent: Thursday, October 24, 2002 1:49 PM To: Multiple recipients of list ORACLE-L

Hi
I am thinking to change our few dictinary manages tablespace to locally managed tablespace.Can any one experienced any issues with locally managed tablespace?
Do any one experience what gain after changing to locally managed tablespace?

Thx
-Seema

--

Please see the official ORACLE-L FAQ: http://www.orafaq.com
--

Author: Deshpande, Kirti
  INET: kirti.deshpande_at_verizon.com

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services

---------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). Received on Fri Oct 25 2002 - 09:28:34 CDT

Original text of this message

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