ORA-04031: unable to allocate 32 bytes of shared memory ("shared pool","insert into AppLog nolo...","sql area","kglhin: temp")

Question

什么问题呢????? 
郁闷得很呢 
JAVA代码和SQL又没问题

Answer 1

查看shared_poo的大小:
show parameter shared_pool如果很小，修改大点就可以了.
alter system set shared_pool_size=300M;

Answer 2

SQL> show parameter shared_pool NAME                                 TYPE        VALUE
------------------------------------ ----------- -----------------------------
shared_pool_reserved_size            big integer 9M
shared_pool_size                     big integer 0
SQL> 
现在怎么做???

Answer 3

上面的写错
应该是5M
SQL> show parameter shared_pool NAME                                 TYPE        VALUE
------------------------------------ ----------- ------------------------------
shared_pool_reserved_size            big integer 5M
shared_pool_size                     big integer 0
SQL> 

Answer 4

SQL> show parameter shared_pool NAME                                 TYPE        VALUE
------------------------------------ ----------- ------------------------------
shared_pool_reserved_size            big integer 5M
shared_pool_size                     big integer 0
SQL> show parameter sga NAME                                 TYPE        VALUE
------------------------------------ ----------- ------------------------------
lock_sga                             boolean     FALSE
pre_page_sga                         boolean     FALSE
sga_max_size                         big integer 160M
sga_target                           big integer 160M
SQL> 

Answer 5

修改：
alter system set sga_max_size=400m scope=spfile;
alter system set sga_target=400m scope=spfile;
重启数据库

Answer 6

alter system set shared_pool_size=300M; alter system set sga_max_size=400m scope=spfile; alter system set sga_target=400m scope=spfile; 
三条都执行吗?
另外,shared_pool_reserved_size要不要修改?
真太感谢您了,亲爱的DBA

Answer 7

我的机器配置,8G内存的DELL 2950
只是做的ORACLE服务器,上面跑了个JAVA的数据采集的服务
您觉得怎么设置合适

Answer 8

修改后变成了这样,OK了没?
SQL> show parameter shared_pool NAME                                 TYPE        VALUE
------------------------------------ ----------- ------------------------------
__shared_pool_size                   big integer 304M
_dm_max_shared_pool_pct              integer     1
_io_shared_pool_size                 big integer 4M
_shared_pool_max_size                big integer 0
_shared_pool_reserved_min_alloc      big integer 4400
_shared_pool_reserved_pct            integer     5
shared_pool_reserved_size            big integer 15M
shared_pool_size                     big integer 300M
SQL> show parameter sga NAME                                 TYPE        VALUE
------------------------------------ ----------- ------------------------------
_4031_sga_dump_interval              integer     3600
_4031_sga_max_dumps                  integer     10
_lock_sga_areas                      integer     0
lock_sga                             boolean     FALSE
pre_page_sga                         boolean     FALSE
sga_max_size                         big integer 400M
sga_target                           big integer 400M
SQL> 

Answer 9

sga_target太小了。
8g ram的话.
sga_max_size=4g
sga_target=4g
db_cache_size=2g

Answer 10

麻烦你给一个最终的\完整的修改方案和SQL语句吧谢谢了