修改processes参数的值，再次启动系统
SQL> alter system set processes=500 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 2000
已选择8行。
从上面几次修改processes参数的值，可以看出每个进程将会在shared pool中分配4字节内存，那此4字节信息是什么呢?我们查看如下的v$process视图
SQL> desc v$process;
责任编辑：虫虫
您现在的位置： 