Re: Locally Managed Tablespace Survey

Jonathon,

While I haven't used them yet, the instructor of the internals class I took said that Oracle is advocating locally managed tablespaces these days. And that in a future release, SYSTEM will also be able to be created as locally managed.

Rachel

>From: Jonathan Gennick <jonathan_at_gennick.com>
>Reply-To: ORACLE-L_at_fatcity.com
>To: Multiple recipients of list ORACLE-L <ORACLE-L_at_fatcity.com>
>Subject: Locally Managed Tablespace Survey
>Date: Thu, 15 Jun 2000 11:49:16 -0800
>
>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.
>
>Thanks,
>
>Jonathan
>
>_____________________________________________________
>jonathan_at_gennick.com
>http://gennick.com
>Brighten the Corner Where You Are
>--
>Author: Jonathan Gennick
> INET: jonathan_at_gennick.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).