RE: ora 4031

From: Trassens Christian <trassenc_at_TELEFONICA.COM.AR>
Date: Tue, 25 Jul 2000 17:11:29 -0300
Message-Id: <10569.112935@fatcity.com>

Try increasing shared_pool_reserved_size and pinning STANDARD package. Maybe you need to increase shared_pool_size too.

Regards.

> -----Mensaje original-----
> De: babu.nagarajan_at_mail.iflexsolutions.com
> [SMTP:babu.nagarajan_at_mail.iflexsolutions.com]
> Enviado el: Martes 25 de Julio de 2000 11:59
> Para: Multiple recipients of list ORACLE-L
> Asunto: ora 4031
>
> Hi
>
> I have suddenly started experiencing this error on my dev database
>
> ORA-04031: unable to allocate 4096 bytes of shared memory ("shared
> pool","STANDARD","PL/SQL MPCODE",
> "BAMIMA: Bam Buffer")
>
> This is 816 on Sun. Is this a case of excessive fragmentation in the
> shared pool? Or is the shared pool itself too small.
>
> Babu Nagarajan
> i-Flex, Bangalore
> #91-80-5597600-3381
Received on Tue Jul 25 2000 - 15:11:29 CDT