Re: Question on gathering System Statistics

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
>

-- 
Mladen Gogala
Database Consultant
https://dbwhisperer.wordpress.com


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