Shared Pool与processes参数的关系

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行。

　　修改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

　　SQL> desc v$process;

　　名称 是否为空? 类型

　　----------------- -------- ---------------

　　ADDR RAW(4)

　　PID NUMBER

　　SPID VARCHAR2(12)

　　USERNAME VARCHAR2(15)

　　SERIAL# NUMBER

　　TERMINAL VARCHAR2(16)

　　PROGRAM VARCHAR2(64)

　　TRACEID VARCHAR2(255)

　　BACKGROUND VARCHAR2(1)

　　LATCHWAIT VARCHAR2(8)

　　LATCHSPIN VARCHAR2(8)

　　PGA_USED_MEM NUMBER

　　PGA_ALLOC_MEM NUMBER

　　PGA_FREEABLE_MEM NUMBER

　　PGA_MAX_MEM NUMBER