| 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
LMT is an 8i new feature and I learned it mostly from Oracle docs and the
8i new features training class from Oracle.
But before folks jump onto the band wagon here, I would like to point out
that use of LMT will invalidate space scripts that uses SYS.FET$ and
SYS.UET$. Also performance wise significant benefits can only be seen on
databases that do a lot of allocation and deallocation of space, things
like dropping and creating tables. These
a lot of times can be better resolved with application tuning.
Just my $0.02
Dennis Meng
Database Administrator
Focal Communications
847-954-8328
Steven Monaghan
<Steve.Monaghan To: Multiple recipients of list ORACLE-L
@wcom.com> <ORACLE-L_at_fatcity.com>
Sent by: cc:
root_at_fatcity.co Subject: RE: Locally Managed Tablespace
m Survey
06/16/00 02:47
PM
Please respond
to ORACLE-L
Lately, the list has been filled with talk of 'locally managed
tablespaces'.
Does anyone have any links to sites that will tell me what they are and
what
they do? I am assuming they are new to either 8 or 8i, since we are still
on 7.3.2 (for a few more weeks anyway!) and I haven't heard of them.
TIA,
Steve Monaghan
Worldcom
Long Island, NY, USA
> -----Original Message-----
> From: root_at_fatcity.com [mailto:root_at_fatcity.com]On Behalf Of Charlie
> Mengler
> Sent: Friday, June 16, 2000 1:07 PM
> To: Multiple recipients of list ORACLE-L
> Subject: 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).
> >
> >
-- Author: Steven Monaghan INET: Steve.Monaghan_at_wcom.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 inReceived on Fri Jun 16 2000 - 16:48:50 CDT
 |
 |