Skip to Main Content

Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

No rows in memory advice

happy10319Nov 13 2019 — edited Nov 13 2019

Hi,

On 11.2.0.4 no row in v$memory_target_advice:

SQL> select * from v$memory_target_advice order by memory_size;

no rows selected

SQL> show parameter memory

NAME                                 TYPE        VALUE

------------------------------------ ----------- ------------------------------

hi_shared_memory_address             integer     0

memory_max_target                    big integer 0

memory_target                        big integer 0

shared_memory_address                integer     0

What should I enable to populate it?

Should set memory_max_target?

Thanks

This post has been answered by Jonathan Lewis on Nov 13 2019
Jump to Answer
Comments
Post Details
Added on Nov 13 2019
3 comments
678 views