Re: 19C migration

Thank You. Yes definitely these two things 1)Private UNDO for writing into temp tables on the DR side and creating exchange table on the fly are helpful ones.

 And considering there's a big gap between 11.2.0.4 and 19C. Wanted to understand what all such features we should consider using while moving to 19C? Is there a good list as such?

On Fri, Dec 10, 2021 at 3:23 PM Lok P <loknath.73_at_gmail.com> wrote:

> I see your other post in which creating a partition exchange table on the
> fly without going for CTAS or dbms_metadata path is also a good one to
> add/modify your code and list of features you are looking to implement in
> your application code. Though it may not be performance related.
>
> On Thu, Dec 9, 2021 at 12:50 AM Pap <oracle.developer35_at_gmail.com> wrote:
>
>> Not much idea about it but what i am aware of is we are using ZDLRA for
>> backup of this engineered system.
>>
>> And I was trying to understand here overall if any specific feature of
>> 19C we should use. It may be performance related.
>>
>>
>>
>> On Wed, Dec 8, 2021 at 7:17 PM Michael McMullen <ganstadba_at_hotmail.com>
>> wrote:
>>
>>> Hi
>>>
>>> Quick question
>>> I noticed you are on an x8-M. Are you using rman compression to a ZFS?
>>> I'm seeing a lot of slowness with compression on our x8 systems.
>>>
>>> Thanks
>>>
>>> Mike
>>> ------------------------------
>>> *From:* oracle-l-bounce_at_freelists.org <oracle-l-bounce_at_freelists.org>
>>> on behalf of Pap <oracle.developer35_at_gmail.com>
>>> *Sent:* December 3, 2021 4:16 AM
>>> *To:* Oracle L <oracle-l_at_freelists.org>
>>> *Subject:* 19C migration
>>>
>>> Hello Listers, We have one of the big hybrid (catering to Oltp+reporting
>>> type of workload) databases(~150TB in size) which is planned to move from
>>> 11.2 to 19C. it's already on an X8-M high capacity exadata box.
>>>
>>> I understand with most of the databases now on 19C+ versions and with
>>> many new features with this version as compared to 11.2.0.4, is there any
>>> key learning we should follow or say are there any specific features we
>>> must use or let our application code change to use to get best out of 19C
>>> in this upgrade? May be related to optimization, compression etc.
>>>
>>

--
http://www.freelists.org/webpage/oracle-l