Configurações de Amostra para Operações Encadeadas

As amostras de configuração a seguir acompanham a Tabela 2-1. Há um exemplo para cada arquitetura do sistema.

64 bits (16 núcleos)

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

64 bits (32 núcleos)

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

64 bits (16 núcleos) e Dois Bancos de Dados

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

Oracle Exalytics In-Memory Machine, 40 núcleos, X2-4

Armazenamento em bloco:

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

Armazenamento agregado:

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

Oracle Exalytics In-Memory Machine, núcleo do SPARC 128

Armazenamento em bloco:

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

Armazenamento agregado:

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

Oracle Exalytics In-Memory Machine, 60 núcleos, X4-4

Armazenamento em bloco:

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

Armazenamento agregado:

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