Re: Things to consider during upgrade/migration

On 11/13/2021 1:46 PM, Lok P wrote:
>
> Hello Listers, With respect to havinga safe upgrade(say from 11.2 to
> 19C) or migration(From HP to Exadata) experience with minimal
> performance issues. Is there any guideline we should follow like
> settingup exadata system stats in case the targetdatabase is going to
> be exadata, Or verifying dictionary stats/table stats etc in a certain
> way. Want to know experts' views, if there are any such guidelines?
>
> Regards
>
> Lok
>
Hi Lok!

The old Itanic-based HP is very different from Exadata, approximately as much as Ford model T is different from Tesla model S. IT technology development has happened at slightly faster pace than the automotive technology development.  Also, Oracle 19c is very different from Oracle 11g. Your thinking should start from the nature of your application. Is that a data warehouse/reporting database type of application? Is it OLTP? Is it mixed mode? Do you need a dedicated service with preferred instance in case of an OLTP? Would mounting some instances in read mostly mode benefit you in any way? Should you make use of heat maps? You have that option with Exadata.

Exadata is primarily a data warehouse accelerator. Bloom filters on the storage nodes are meant to increase the speed of the full table scan. However, Exadata X8-2, the model that is mostly being sold these days, has some very interesting features like RDMA (direct memory access over the network) and persistent memory access, a form of extremely fast SSD which can tremendously speed up commit processing. That would be very important for an OLTP application. In other words, you will have to re-tune your application all over again. To quote the late Yogi Berra, "it's a deja vu all over again". The first thing to do is to get acquainted with your new wonder of technology and learn what can it do. Use fio or bonnie++ to measure IOPS. Use SLOB to see what Oracle can do with that. After that start testing the application in earnest, always having in mind that you might have to re-architect some pieces of it.

As far as system statistics is concerned, Oracle advises against that. I  once contacted Maria Colgan (aka "SQL Maria") directly with some questions about that advice and she explained to me why is that the official line. With Exadata, you will have Oracle Support on steroids. They will extend any help that they can give on a very short notice. They really do care about the Exadata customers.

-- 
Mladen Gogala
Oracle DBA
Tel: (347) 321-1217
Blog: https://dbwhisperer.wordpress.com

--
http://www.freelists.org/webpage/oracle-l