Has anyone taken a PROD DB and changed it to using LMTSs and then noticed a perf
change + or -?
---
TheOracleDBA
theoracledba_at_lycos.com
On Tue, 30 Jan 2001 10:30:29
Bunyamin K.Karadeniz wrote:
> 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 <ORACLE-L_at_fatcity.com>
>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: SMALKUNS_at_SYSTEMS.TEXTRON.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: Bunyamin K.Karadeniz
> INET: bunyamink_at_havelsan.com.tr
>
>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 small business started at Lycos Small Business at
http://www.lycos.com/business/mail.html
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: The Oracle DBA
INET: theoracledba_at_lycos.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).
Received on Tue Jan 30 2001 - 14:17:43 CST
