Re: 19C migration

Thank you So much for this information. This database feature app looks like a really nice way of listing down the new features.

On Sat, Dec 11, 2021 at 4:49 AM Mikhail Velikikh <mvelikikh_at_gmail.com> wrote:

> 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