Re: Locally Managed Tablespace Survey

Another way under V8.1.6 is to -

The statement to convert TBS_1 to a locally managed tablespace is as follows:

EXEC DBMS_SPACE_ADMIN.TABLESPACE_MIGRATE_TO_LOCAL ('tbs_1');

HTH & YMMV! Oracle General wrote:
>
> Here's a quote from the Oracle Applications 11i Upgrade Manual. This I guess
> clearly shows Oracle's direction.
> -------------------------------------------------------------------
> Oracle Applications recommends the use of local extent management to
> increase performance. To convert all non-SYSTEM tablespaces from Data
> Dictionary extent management to local extent management, run the following
> script:
> From the UNIX prompt:
> $ cd $APPL_TOP/admin/preupg
> $ sqlplus <SYSTEM username>/<SYSTEM password> @adtbscnv.pls \
> <SYSTEM password>
> --------------------------------------------------------------------
>
> Manish
> -----Original Message-----
> Sent: Thursday, June 15, 2000 7: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: Oracle General
> INET: OracleGeneral_at_mwd.dst.ca.us
>
> 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).

-- 
Charlie Mengler                               Maintenance Warehouse  
charliem_at_mwh.com                              5505 Morehouse Drive   
858-552-6229                                  San Diego, CA 92121