从上面的错误说明，oracle会根据processes参数的值在共享池中分配一定数量的内存，参数值越大，分配的内存也越多。
将processes参数调整到100个，重新启动系统
SQL> show parameter processes;
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
aq_tm_processes integer 0
db_writer_processes integer 1
gcs_server_processes integer 0
job_queue_processes integer 10
log_archive_max_processes integer 2
processes integer 100
SQL> select * from v$sgastat where pool='shared pool' and name like '%process%';
POOL NAME BYTES
------------ -------------------------------------------------- ----------
shared pool generic process shared st 12
shared pool ksb ci process list (each 348
shared pool process count for each CI 288
shared pool ksb cic process list 288
shared pool Background process state 48
shared pool process group array 25352
shared pool ksb process so list 288
shared pool processes 400
已选择8行。
责任编辑：虫虫
您现在的位置： 