Re: 19C migration

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