Configurazioni di esempio per operazioni con thread

Gli esempi di configurazione seguenti accompagnano la Tabella 2-1. È disponibile un esempio per ogni architettura di sistema.

64 bit (16 core)

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

64 bit (32 core)

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

64 bit (16 memorie centrali) e due database

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

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

Memorizzazione a blocchi:

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

Memorizzazione di aggregazione:

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

Oracle Exalytics In-Memory Machine, SPARC 128 core

Memorizzazione a blocchi:

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

Memorizzazione di aggregazione:

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

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

Memorizzazione a blocchi:

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

Memorizzazione di aggregazione:

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