RE: 19C migration

I believe that will be too long a list.  

I believe a useful way to go about this is to order your jobs by duration, consider what they do, and look directly in 19c to see what could improve that job.  

There are also “what’s new in xx.x” notes for each major release, but you’ll need to read each one.  

mwf  

From: oracle-l-bounce_at_freelists.org [mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Pap Sent: Friday, December 10, 2021 3:01 PM
To: Karthikeyan Panchanathan
Cc: Lok P; Michael McMullen; Oracle L
Subject: Re: 19C migration  

Thank You Karthikeyan for this information.  

 Is there a list of key new features i.e. delta difference between 11.2 and 19C which we can follow?  

On Fri, Dec 10, 2021 at 4:31 PM Karthikeyan Panchanathan <keyantech_at_gmail.com> wrote:

In any case if you have any DBMS_JOB in 11.2.0.4 please convert to DBMS_SCHEDULER before moving to Oracle 19c.  

Of course during upgrade Oracle create DBMS_SCHEDULER for every DBMS_JOB but it is deprecated. Seen few issues.      

Get Outlook for iOS <https://aka.ms/o0ukef>

From: oracle-l-bounce_at_freelists.org <oracle-l-bounce_at_freelists.org> on behalf of Pap <oracle.developer35_at_gmail.com> Sent: Friday, December 10, 2021 5:13:11 AM To: Lok P <loknath.73_at_gmail.com>
Cc: Michael McMullen <ganstadba_at_hotmail.com>; Oracle L <oracle-l_at_freelists.org> Subject: 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