Oracle报错问题

ORA-04031:无法分配4084字节的共享内存(“shared pool”,”standardsys”,”PL/sql mpcode”,”bamima:bam buffer”)


我写了一个接口程序，把sql2000里的数据导入到oralce数据库中，偶然一天接口程序发生以上错误提示，这是什么原因呢

---

ORA-04031: unable to allocate string bytes of shared memory ("string","string","string","string")
Cause: More shared memory is needed than was allocated in the shared pool.

Action: If the shared pool is out of memory, either use the dbms_shared_pool package to pin large packages, reduce your use of shared memory, or increase the amount of available shared memory by increasing the value of the INIT.ORA parameters "shared_pool_reserved_size" and "shared_pool_size". If the large pool is out of memory, increase the INIT.ORA parameter "large_pool_size".

---

shared pool大小不够了
需要增大

如果你没有权限 并且不知道怎么增大
联系你的数据库管理员吧

---

我就是数据库管理员，怎么增加啊

---

数据库什么版本

---

SQL code:
SQL> conn / as sysdba --以dba身份登录
Connected.
SQL> show parameter spfile --看数据库是否在使用spfile

NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
spfile