线程操作的配置样例

Table 2-1 附带了以下配置样例。每个系统体系结构都有一个示例。

64 位（16 个核心）

WORKERTHREADS 50
SERVERTHREADS 100
AGENTTHREADS 30
DLTHREADSPREPARE 2
DLTHREADSWRITE 2
EXPORTTHREADS 8
RESTRUCTURETHREADS 2

64 位（32 个核心）

WORKERTHREADS 50
SERVERTHREADS 100
AGENTTHREADS 30
DLTHREADSPREPARE 2
DLTHREADSWRITE 2
EXPORTTHREADS 8
RESTRUCTURETHREADS 2

64 位（16 个核心）和两个数据库

WORKERTHREADS 50
SERVERTHREADS 100
AGENTTHREADS 30
DLTHREADSPREPARE 2
DLTHREADSWRITE 2
EXPORTTHREADS 8
RESTRUCTURETHREADS 4

Oracle Exalytics In-Memory Machine，40 个核心，X2-4

块存储：

WORKERTHREADS 50
SERVERTHREADS 100
AGENTTHREADS 30
DLTHREADSPREPARE 2
DLTHREADSWRITE 2
EXPORTTHREADS 40
RESTRUCTURETHREADS 8

聚合存储：

WORKERTHREADS 50
SERVERTHREADS 100
AGENTTHREADS 30
DLTHREADSPREPARE 24
DLTHREADSWRITE 2
EXPORTTHREADS 40
RESTRUCTURETHREADS 8

Oracle Exalytics In-Memory Machine、SPARC 128 核心

块存储：

WORKERTHREADS 100
SERVERTHREADS 200
AGENTTHREADS 30
DLTHREADSPREPARE 2
DLTHREADSWRITE 2
EXPORTTHREADS 40
RESTRUCTURETHREADS 8

聚合存储：

WORKERTHREADS 100
SERVERTHREADS 200
AGENTTHREADS 30
DLTHREADSPREPARE 24
DLTHREADSWRITE 2
EXPORTTHREADS 40
RESTRUCTURETHREADS 8

Oracle Exalytics In-Memory Machine，60 个核心，X4-4

块存储：

WORKERTHREADS 60
SERVERTHREADS 120
AGENTTHREADS 30
DLTHREADSPREPARE 2
DLTHREADSWRITE 2
EXPORTTHREADS 40
RESTRUCTURETHREADS 8

聚合存储：

WORKERTHREADS 60
SERVERTHREADS 120
AGENTTHREADS 30
DLTHREADSPREPARE 24
DLTHREADSWRITE 2
EXPORTTHREADS 40
RESTRUCTURETHREADS 8