Wednesday, May 4, 2016

ORA-00845: MEMORY_TARGET not supported on this system

ORA-00845: MEMORY_TARGET not supported on this system

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

SQL> show parameter memory

NAME     TYPE VALUE
------------------------------------ ----------- ------------------------------
hi_shared_memory_address     integer 0
inmemory_clause_default     string
inmemory_force     string DEFAULT
inmemory_max_populate_servers     integer 0
inmemory_query     string ENABLE
inmemory_size     big integer 0
inmemory_trickle_repopulate_servers_ integer 1
percent
memory_max_target     big integer 1488M
memory_target     big integer 1488M
optimizer_inmemory_aware     boolean TRUE
shared_memory_address     integer 0