[oracle]ORA-04031: unable to allocate bytes of shared memory ("shared pool","unknown object","KKSSP^405","kglseshtTable")

云博小周宇2024年5月5日2023年8月17日1 Min Read

问题: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=5G scope=spfile;

System altered.