Re: 19C migration

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

There is the Database Features app:
https://apex.oracle.com/database-features/ Select 11.2 and 19c, tick 'New features only' [image: image.png]
There are 898 features for this selection. You can specify your Focus Area and one or more Sub Areas that you are interested in.

On Fri, 10 Dec 2021 at 20:30, Mark W. Farnham <mwf_at_rsiz.com> wrote:

> 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





image/png attachment: image.png