[Oralce]执行sql共享池报错ORA-04031: unable to allocate 4120 bytes of shared memory (“shared pool“,...)

大概率是缓存给小了
解决方案:

1. 刷共享池,说在数据库使用量大的时候执行,可能会导致宕机,所以本人没有尝试过

alter system flush shared_pool;

2. 修改缓存大小,需要重启服务器以后才能生效

[oracle@localhost ~]$ sqlplus / as sysdba
SQL> show parameter sga;
SQL> alter system set sga_max_size=2048m scope=spfile;
SQL> alter system set sga_target=2048m scope=spfile;
SQL> shutdown immediate;
SQL> startup;
SQL> show parameter sga;
SQL> quit;

参考文档
http://blog.chinaunix.net/uid-20802110-id-4188357.html
https://www.parnassusdata.com/zh-hans/node/771