RE: Locally Managed Tblsp. Vs Dictionary Managed Tblsp.

Happy New Year!

Agreed! I like so much with locally managed tablespace because every extent size is uniform, therefore no fragmentation; you don't have to worry about the number of extents at the table level. I even make the temporary tablespace to be LMT.

What is the acceptable extent size if you mix large tables with small tables (in terms of nbr of rows) in one tablespace? For example: you have 20 tables; 10 of them will have only less than 1000 rows, 5 of them will have less than 20000 rows and the rest will have 100000 rows or more. Now what is the appropriate extent size for the tablespace if you decide to create only one tablespace for all 20 tables? If you split into 3 tablespaces, then you can easily set the extent size for each. Please don't let it frustrate you! If you are very concerned with wasting space, then you should split into more tablespaces.  

-----Original Message-----
To: Multiple recipients of list ORACLE-L Sent: 1/2/02 2:15 AM

Connor McDonald wrote:
>
> Dictionary managed tspaces are practically
> obsolete...Go with locally managed - they are the
> default in 9i and as of 9i.2, *all* tablespaces will
> default to locallly managed (including system)
>
> hth
> connor
>
> --- Arul kumar <rakumar_at_mahindrabt.com> wrote: > Hi
> DBAs,
> >
> > I would like to know on what basis we arrive at the
> > decision of making a
> > tablespace as LOCALLY Managed / DICTIONARY
> > Managed...
> >
> > Any Suggestions / Tips....
> >
> > Thank you..
> >
> > Arul.
> >
> >
> *********************************************************
> > Disclaimer
> >
> > This message (including any attachments) contains
> > confidential information intended for a specific
> > individual and purpose, and is protected by law.
> > If you are not the intended recipient, you should
> > delete this message and are hereby notified that
> > any disclosure, copying, or distribution of this
> > message, or the taking of any action based on it,
> > is strictly prohibited.
> >
> >
> *********************************************************
> > Visit us at http://www.mahindrabt.com
> > --
> > Please see the official ORACLE-L FAQ:
> > http://www.orafaq.com
> > --
> > Author: Arul kumar
> > INET: rakumar_at_mahindrabt.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).
>
> =====
> Connor McDonald

Sybasation ;-) ?

-- 
Regards,

Stephane Faroult
Oriole Ltd
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Stephane Faroult
  INET: sfaroult_at_oriole.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).
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Wong, Bing
  INET: bing.wong_at_IngramMicro.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).