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