Re: How to revert to DMTS ?
From: Gerard H. Pille <ghp_at_skynet.be>
Date: Thu, 30 Sep 2010 21:21:35 +0200
Message-ID: <4ca4e33e$0$14254$ba620e4c_at_news.skynet.be>
Mladen Gogala wrote:
> On Thu, 30 Sep 2010 19:43:41 +0200, Gerard H. Pille wrote:
>
>> Hallo,
>>
>> for performance reasons I need a couple of dictionary managed
>> tablespaces
>
> What, exactly, is the performance problem that the dictionary managed
> tablespaces would solve?
>
>
>
Excessive undo on intensive deletes and inserts in indexes, multiple sessions inserting (DMTS + freelists) and slower full table scans. Received on Thu Sep 30 2010 - 14:21:35 CDT
Date: Thu, 30 Sep 2010 21:21:35 +0200
Message-ID: <4ca4e33e$0$14254$ba620e4c_at_news.skynet.be>
Mladen Gogala wrote:
> On Thu, 30 Sep 2010 19:43:41 +0200, Gerard H. Pille wrote:
>
>> Hallo,
>>
>> for performance reasons I need a couple of dictionary managed
>> tablespaces
>
> What, exactly, is the performance problem that the dictionary managed
> tablespaces would solve?
>
>
>
Excessive undo on intensive deletes and inserts in indexes, multiple sessions inserting (DMTS + freelists) and slower full table scans. Received on Thu Sep 30 2010 - 14:21:35 CDT