Re: ora 4031

Babu Nagarajan,

This is directly from Oracle - short answer, increase SHARE_POOL_SIZE initialization parameter.

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.

Hope this helps you out.

Regards,

Phil Lima

SCT Global Government Solutions

                                                                       =


                                                =20

                    babu.nagarajan_at_mail.iflexsol                       =


                                                =20

                    utions.com                          To:     Multipl=
e recipients of list ORACLE-L                   =20
                    Sent by: root_at_fatcity.com           <ORACLE-L_at_fatci=
ty.com>                                         =20
                                                        cc:            =


                                                =20

                                                        Subject:     or=
a 4031                                          =20
                    07/25/00 10:59 AM                                  =


                                                =20

                    Please respond to ORACLE-L                         =


                                                =20

                                                                       =


                                                =20

                                                                       =


                                                =20

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. Received on Tue Jul 25 2000 - 14:08:26 CDT