Oracle FAQ Your Portal to the Oracle Knowledge Grid

Home -> Community -> Mailing Lists -> Oracle-L -> RE: Locally Managed Tablespace Survey

RE: Locally Managed Tablespace Survey

From: Gait, Christopher <>
Date: Sun, 18 Jun 2000 11:35:05 -0400
Message-Id: <>

Sorry not to give specific answers to all your survey questions, but here is all we are doing with LMTs now:

I have a locally managed temporary tablespace on one non-production instance. I am planning to use a LMT for a production temporary space in the near future. I don't think locally managed tablespaces are ready for primetime. There are enough things one has to check on a production database without doing periodic checks to make sure you don't have corrupt LMTs. Temporary tablespaces, on the other hand, are constantly allocating and deallocating space, and thus gain performance from LMTs, and can easily be blown away and recreated in case of trouble.

Chris Gait
Oracle DBA
Arlington, VA

-----Original Message-----
From: Jonathan Gennick [] Sent: Thursday, June 15, 2000 3:49 PM
To: Multiple recipients of list ORACLE-L Subject: Locally Managed Tablespace Survey

I'm writing a magazine article on locally managed tablespaces, and I'd like to get some opinions and feedback from anyone who might be using these in a production environment. If you are using locally managed tablespaces, and you could find the time to answer the following questions, I'd be grateful. I'm sure others on this list would find the answers interesting as well.

Are you currently using locally managed tablespaces in a production environment?

Do you see locally managed tablespaces as the preferred tablespace type going forward?

Have you kept any tablespaces as dictionary managed, and why?

Have you used the AUTOALLOCATE feature to allow Oracle to size your extents automatically?

Have you encountered any specific problems with locally managed tablespaces that other DBAs should be aware of?

Do you over use DBMS_SPACE_ADMIN to verify or fix the bitmaps in your locally managed tablespaces? Do you do this on a regular basis, or only when a problem occurs?

Have you ever had a problem where you _needed_ to run DBMS_SPACE_ADMIN in order to fix it?

Have you noticed any measurable performance improvement as a result of using locally managed tablespaces?

That's it. Not too many questions, I hope. Of course, if you can think of anything useful to add that I havn't asked about, that would be great too.


Brighten the Corner Where You Are
Author: Jonathan Gennick

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: (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
Received on Sun Jun 18 2000 - 10:35:05 CDT

Original text of this message