在开发项目当中,程序报错信息如下:
java.lang.RuntimeException: java.sql.SQLException: ORA-04031: 无法分配 4064 字节的共享内存 ("shared pool","INSERT INTO t_pm(PM_CODE, NA...","sga heap(1,0)","kglsim heap")
Query: INSERT INTO t_pm(PM_CODE, NAME, ALLPINYIN, PINYIN, JOIN_PM_DATE, CARD_NO, MOBILE_NO, SEX, BIRTH_DATE, FULL_PM_DATE) VALUES ('3607020060015001','袁峰','yuanfeng','yf',to_date('1900-01-01', 'yyyy-MM-dd'),'123456789','13648670794','1',to_date('1973-01-16', 'yyyy-MM-dd'),to_date('1900-01-01', 'yyyy-MM-dd')) Parameters: []
at com.stransfer.dbhelper.DatabaseHelper.update(DatabaseHelper.java:254)
at com.stransfer.dbhelper.DatabaseHelper.insertEntityWithDate(DatabaseHelper.java:334)
at com.stransfer.main.PmTransfer.importToDb(PmTransfer.java:267)
at com.stransfer.main.PmTransfer.migrate(PmTransfer.java:75)
at com.stransfer.main.Main.main(Main.java:28)
Caused by: java.sql.SQLException: ORA-04031: 无法分配 4064 字节的共享内存 ("shared pool","INSERT INTO t_pm(PM_CODE, NA...","sga heap(1,0)","kglsim heap")
Query: INSERT INTO t_pm(PM_CODE, NAME, ALLPINYIN, PINYIN, JOIN_PM_DATE, CARD_NO, MOBILE_NO, SEX, BIRTH_DATE, FULL_PM_DATE) VALUES ('3607020060015001','袁峰','yuanfeng','yf',to_date('1900-01-01', 'yyyy-MM-dd'),'123456789','13648670794','1',to_date('1973-01-16', 'yyyy-MM-dd'),to_date('1900-01-01', 'yyyy-MM-dd')) Parameters: []
at org.apache.commons.dbutils.AbstractQueryRunner.rethrow(AbstractQueryRunner.java:392)
at org.apache.commons.dbutils.QueryRunner.update(QueryRunner.java:491)
at org.apache.commons.dbutils.QueryRunner.update(QueryRunner.java:377)
at com.stransfer.dbhelper.DatabaseHelper.update(DatabaseHelper.java:251)
... 4 more
查了相关博客,是由于oracle的shared_pool空间不够的原因,解决方法:
第一种:治标不治本。
alter system flush shared_pool;
这种方法可以立即有效果,但是不是根本的解决办法,一小时左右又开始报上面的错误了,再次执行就可以了。
第二种:治标又治本。
ALTER SYSTEM SET SHARED_POOL_SIZE='100M' SCOPE=spfile;
然后重启下:
sql>shutdown immediate
sql>startup
转载地址:https://blog.csdn.net/huangbaokang/article/details/80438946