Shared Pool与processes参数的关系

核心提示： 将processes参数调整到100个，重新启动系统SQL> show parameter processes;NAME TYPE VALUE --- --aq_tm_processes integer 0db_writer_processes integer 1gcs_server

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

从上面几次修改processes参数的值，可以看出每个进程将会在shared pool中分配4字节内存，那此4字节信息是什么呢?我们查看如下的v$process视图

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)