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 tablespaces

RE: Locally managed tablespaces

From: Karniotis, Stephen <Stephen_Karniotis_at_compuware.com>
Date: Fri, 14 Dec 2001 13:42:18 -0800
Message-ID: <F001.003DD01B.20011214130517@fatcity.com>

Heather:

  Another thing to consider. If the vendor of your student application system has not worked with LMTs, you may encounter support issues should you have problems with database accessibility. I would verify that LMTs are supported before converting.

  In terms of usage, LMTs are great as they remove all of the ridiculous I/O encountered by the SYSTEM tablespace for monitoring extent performance, allocation, and deallocation. Denise is correct that uniform extents significantly improve the performance of LMTs, however, multiple uniform extent types can be used. However, if your extent sizes are all over the map, you should create some uniform size and then move to LMT.

Thank You

Stephen P. Karniotis
Technical Alliance Manager
Compuware Corporation
Direct: (248) 865-4350
Mobile: (248) 408-2918
Email: Stephen.Karniotis_at_Compuware.com
Web: www.compuware.com

 -----Original Message-----
Sent: Friday, December 14, 2001 3:26 PM

To:     Multiple recipients of list ORACLE-L
Subject:        RE: Locally managed tablespaces

Heather - Is there a particular reason the consultant is doing this other than maybe this is the first opportunity to learn this? Just my cynical side. Mentioning cynical, I was leery of the procedure to convert an existing dictionary-managed tablespace to a locally-managed one, but we production DBAs tend to be a conservative lot. If you go that route, be sure that you end up with uniform extents which I consider the best part of LMT.

        Be sure to study the paper "How to Stop Defragmenting and Start Living: The Definitive Word on Fragmentation" by Himatsingka and Loaiza. before your consultant comes so that both of you agree on the approach to take. This is available on Oracle's Web site. The worst circumstance (see cynical above) would be for one person to create them and the other person to maintain them, but each with a different philosophy.

        I think LMT and uniform extents and extensible tablespaces are the greatest features Oracle has added recently. Dennis Williams
DBA
Lifetouch, Inc.
dwilliams_at_lifetouch.com

-----Original Message-----
Sent: Friday, December 14, 2001 8:55 AM
To: Multiple recipients of list ORACLE-L

I have just heard today that an external consultant, who is coming to upgrade software for our Student Records system next week, wants to unload the live, test and training databases, and recreate them using locally managed tablespaces.

I've been reading all the incredibly positive things oracle have to say about this, but has anybody any real experience of using locally managed tablespaces, and if so, are there any major disadvantages or knock-on effects that I should be aware of? Apart from trying to find disk space to unload each database to do this, would it have any additional space implications?

Basically, I need to decide if I should let this go ahead.

Heather

--

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

Author: Docherty, Heather
  INET: H.Docherty_at_napier.ac.uk

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
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).
--

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

Author: DENNIS WILLIAMS
  INET: DWILLIAMS_at_LIFETOUCH.COM
Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
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).
--

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

Author: Karniotis, Stephen
  INET: Stephen_Karniotis_at_compuware.com
Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
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 Dec 14 2001 - 15:42:18 CST

Original text of this message

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