报错信息:
ORA-04031: unable to allocate 4000 bytes of shared memory (“shared
pool”,“SELECT NAME NAME_COL_PLUS_SH…”,“sga heap(1,0)”,“kglsim heap”)
错误解决办法
SQL> show parameter shared_pool;
NAME TYPE VALUE
shared_pool_reserved_size big integer 68786585
shared_pool_size big integer 160M
修改共享池大小shared_pool_size
arter system set shared_pool_size=‘200M’ scope=both;
如果还是报错就增大sga,pga
我的物理内存是8G,之前设置的sga,pga过小,可以增大
1、查看SGA信息:
SQL>show parameter sga;
2、修改sga_target
SQL> alter system set sga_target=3200M scope=spfile;
3、修改sga_max_size
SQL> alter system set sga_max_size=3200M scope=spfile;
查看PGA信息:
SQL> show parameter pga;
3、修改pga_aggregate_target
SQL> alter system set pga_aggregate_target=1500M scope=spfile;
4、重启数据库使其生效:
SQL> shutdown immediate;
关不掉就强制关机
shutdown abort;
注意,重启前一定先完成上述两部操作,且sga_target不得大于sga_max_size,一般保持两者相等,否则可能导致数据库无法启动。
SQL> startup