Run sga target advisory - oracle database script

- STATISTICS_LEVEL should be TYPICAL/ALL. SQL> SHOW PARAMETER statistics_level NAME TYPE VALUE ------------------------------------ -------------------------------- --------------------------  statistics_level string TYPICAL  select * from v$sga_target_advice order by sga_size;