Re: 19C migration
Date: Fri, 10 Dec 2021 11:01:50 +0000
Message-ID: <SJ0PR02MB74861DA22ABCE18733F26ECBFF719_at_SJ0PR02MB7486.namprd02.prod.outlook.com>
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>
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<mailto: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<mailto: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<mailto:ganstadba_at_hotmail.com>> wrote:
Hi
Quick question
Thanks
Mike
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.
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
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.
From: oracle-l-bounce_at_freelists.org<mailto:oracle-l-bounce_at_freelists.org> <oracle-l-bounce_at_freelists.org<mailto:oracle-l-bounce_at_freelists.org>> on behalf of Pap <oracle.developer35_at_gmail.com<mailto:oracle.developer35_at_gmail.com>>
Sent: December 3, 2021 4:16 AM
To: Oracle L <oracle-l_at_freelists.org<mailto:oracle-l_at_freelists.org>>
Subject: 19C migration
--
http://www.freelists.org/webpage/oracle-l
Received on Fri Dec 10 2021 - 12:01:50 CET