Fórum erro no Oracle #28345
30/01/2006
0
Pessoal,
Estou com uma dúvida porque que geralmente dá esse erro no Oracle :
ORA-04031: unable to allocate 4160 bytes of
shared memory
Gostaria de estar sabendo as possiveis causas desse erro.
Obrigada.
Pâmella
Estou com uma dúvida porque que geralmente dá esse erro no Oracle :
ORA-04031: unable to allocate 4160 bytes of
shared memory
Gostaria de estar sabendo as possiveis causas desse erro.
Obrigada.
Pâmella
Pamyscruz
Curtir tópico
+ 0
Responder
Posts
30/01/2006
Motta
Do manual :
ORA-04031: unable to allocate num bytes of shared memory num, num, num
Cause: More shared memory is needed than was allocated in the operating system
process. SGA private memory has been exhausted.
Action: Either use the DBMS_SHARED_POOL package to pin large packages,
reduce your use of shared memory, or increase the amount of available shared
memory by increasing the value set for the SHARED_POOL_SIZE initialization
parameter.
_______________________________________________________
O teu sistema tem pouca memoria ou muita foi alocada para a Shared, difícil avaliar a distancia.
ORA-04031: unable to allocate num bytes of shared memory num, num, num
Cause: More shared memory is needed than was allocated in the operating system
process. SGA private memory has been exhausted.
Action: Either use the DBMS_SHARED_POOL package to pin large packages,
reduce your use of shared memory, or increase the amount of available shared
memory by increasing the value set for the SHARED_POOL_SIZE initialization
parameter.
_______________________________________________________
O teu sistema tem pouca memoria ou muita foi alocada para a Shared, difícil avaliar a distancia.
Responder
Gostei + 0
Clique aqui para fazer login e interagir na Comunidade :)