RE: Locally Managed Tablespace Survey

Mladen,

I'm one of those "goody-goody" DBAs who tries really hard not to use "not quite supported" (<G>) things in production... besides, they are talking about it for 8.2, which is pretty close.. I hate living on the bleeding edge anyway, that razor blade HURTS!

Rachel

>From: "Gogala, Mladen" <MGogala_at_oxhp.com>
>Reply-To: ORACLE-L_at_fatcity.com
>To: Multiple recipients of list ORACLE-L <ORACLE-L_at_fatcity.com>
>Subject: RE: Locally Managed Tablespace Survey
>Date: Fri, 16 Jun 2000 07:57:09 -0800
>
>Rachel, you can create it as locally managed now (by tweaking sql.bsq, of
>course)
>and use autoallocate policy. It's not quite supported yet, but it is
>possible.
>
>-----Original Message-----
>Sent: Thursday, June 15, 2000 10:17 PM
>To: Multiple recipients of list ORACLE-L
>
>
>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).
>
>________________________________________________________________________
>Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com
>
>--
>Author: Rachel Carmichael
> INET: carmichr_at_hotmail.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).
>--
>Author: Gogala, Mladen
> INET: MGogala_at_oxhp.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).