1 Reply Latest reply: Oct 10, 2013 8:44 AM by user12075536123 RSS

    Memory advisor "No Data"

    User235837 -Oracle

      Hi

      memory_target=3G

      sga_max_size = 3G

      memory_max_target=4G

       

      AMM enabled ,Database version is 11.2.0.3

       

      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;

       

        COUNT(*)

      ----------

        0

       

      SQL> select count(*) from v$sga_target_advice;

       

        COUNT(*)

      ----------

        0

       

      ( After bouncing database we were able to see data in memory advisor for some time after that no records where there in above table

       

      Thanks