erro no Oracle
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
Curtidas 0
Respostas
Motta
30/01/2006
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.
GOSTEI 0