问题:ORA-04031: unable to allocate 12312 bytes of shared memory ("shared pool","unknown object","KKSSP^405","kglseshtTable")
解决:增加数据库存内存大小,一定注意服务器本身内存,不是任意
SQL> alter system set memory_max_target=2G scope=spfile;
System altered.
SQL> alter system set memory_target=2G scope=spfile;
System altered.
查看修改结果:
SQL> show parameter memory
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
hi_shared_memory_address integer 0
inmemory_adg_enabled boolean TRUE
inmemory_automatic_level string OFF
inmemory_clause_default string
inmemory_expressions_usage string ENABLE
inmemory_force string DEFAULT
inmemory_max_populate_servers integer 2
inmemory_optimized_arithmetic string DISABLE
inmemory_prefer_xmem_memcompress string
inmemory_prefer_xmem_priority string
inmemory_query string ENABLE
inmemory_size big integer 1G
inmemory_trickle_repopulate_servers_ integer 1
percent
inmemory_virtual_columns string MANUAL
inmemory_xmem_size big integer 0
memory_max_target big integer 2G
memory_target big integer 2G
optimizer_inmemory_aware boolean TRUE
shared_memory_address integer 0
注意:启动出现“MEMORY_TARGET not supported on this system”异常,一定要修改dev/shm分区内存
可参照这个方案处理:https://blog.csdn.net/hhj724/article/details/106091948