Hi Amir,
Yes, you should collect system statistics. System statistics, among
other things, calibrates the system I/O and uses it to calculate the
execution plan price. If your Powermax is much faster than your VMAX,
you may want to tell Oracle about that. On the other hand, if you don't
do anything, the plans will remain the same but the execution will be
much faster.
Regards
On 1/26/21 2:30 PM, Hameed, Amir wrote:
--
Hi,
We are in the process of moving our applications from current storage array (VMAX250) to a new array (Powermax). From best practices standpoint, should we collect System Stats after moving to the new storage? If we should then is there a recommended way of gathering System Stats?
Thanks,
Amir