But some had claimed that Locally managed tablespaces are slower. I do
not know if it is correct but you must consider it .
And I wonder the performance results too.
----- Original Message -----
To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
Sent: Tuesday, January 30, 2001 3:35 PM
> I have always been concerned with fragmentation of tablespaces, whether it
> be lots of extents, honeycomb or
> bubble fragmentation. Now I am reading that in Oracle 8i with the use of
> locally-managed table spaces,
> these concerns are a thing of the past as Oracle now uses bit maps within
> the tablespaces themselves to
> do space management. This seems foreign to me that even though Oracle will
> use up all the space in
> the tablespaces with no coalescing, it is OK that extents will go into
the
> thousands with no performance degradation.
> Could folks who are currently using locally managed tablespaces please
> comment on how well it
> is working for them and if they have experienced any problems in using
them.
> Thanks
> Skip
> Here is a good white paper on the subject.
> http://www.embarcadero.com/news/white_papers.htm
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: Malkuns, Skip
> INET: [EMAIL PROTECTED]
>
> 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: [EMAIL PROTECTED] (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: Bunyamin K.Karadeniz
INET: [EMAIL PROTECTED]
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: [EMAIL PROTECTED] (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).
