Exemples de configuration pour les opérations avec threads

Les exemples de configuration suivants accompagnent le Table 2-1. Il existe un exemple pour chaque architecture système.

64 bits (16 coeurs)

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

64 bits (32 coeurs)

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

64 bits (16 coeurs) et deux bases de données

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

Oracle Exalytics In-Memory Machine, 40 coeurs, X2-4

Mode "block storage" :

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

Mode "aggregate storage" :

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

Oracle Exalytics In-Memory Machine, coeur SPARC 128

Mode "block storage" :

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

Mode "aggregate storage" :

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

Oracle Exalytics In-Memory Machine, 60 coeurs, X4-4

Mode "block storage" :

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

Mode "aggregate storage" :

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