sga_max_size = 3G
AMM enabled ,Database version is 18.104.22.168
When we checked memory advisor from OEM it shows NO DATA
Main reason why the Memory Advisor shows No Data is due to no records in v$memory_target_advice view.
SQL> select count(*) from v$memory_target_advice;
SQL> select count(*) from v$sga_target_advice;
( After bouncing database we were able to see data in memory advisor for some time after that no records where there in above table