修改processes参数的值，再次启动系统
SQL> alter system set processes=300 scope=spfile;
系统已更改。
shutdown immediate;
startup;
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 1200
已选择8行。
责任编辑：虫虫
您现在的位置： 