问题:ORA-04031: unable to allocate 12312 bytes of shared memory ("shared pool","unknown object","KKSSP^405","kglseshtTable")
解决:增加数据库存内存大小
SQL> alter system set memory_max_target=4G scope=spfile; System altered. SQL> alter system set memory_target=4G 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 4G memory_target big integer 4G optimizer_inmemory_aware boolean TRUE shared_memory_address integer 0