| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> RE: Locally Managed Tablespace Survey
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-----
From: Rachel Carmichael [mailto:carmichr_at_hotmail.com]
Sent: Thursday, June 15, 2000 10:17 PM
To: Multiple recipients of list ORACLE-L
Subject: 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).
-- 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 mayReceived on Fri Jun 16 2000 - 09:50:32 CDT
 |
 |