Shared memory problem on Oracle 7.2.2

We are quite frequently getting error 4031 from our Oracle 7.2.2 database:  

GST0K1 > oerr ora 4031
04031, 00000, "unable to allocate %s bytes of shared memory (\"%s\",\"%s\",\"%s\")"

// *Cause:  More shared memory is needed than was allocated in the shared
//          pool.
// *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 of the
//          init.ora parameter "shared_pool_size".

The error occurs in an application that performs a large number of relatively small insert transactions. The number of bytes that Oracle is unable to allocate is typically in the range of 100 - 500 bytes.

Our database server is a SparcStation 20 with 32Mb shared memory. The Oracle database has 10 Mb shared memory (init.ora parameter shared_pool_size)

I have verified that the application commits each transaction properly. Does anyone know if this a known problem on Oracle 7.2.2? Is there any workaround?

______________________             __________________________


| Per Eivind Solum    \/\|/\|/\|/\/ Schlumberger Geco-Prakla |

| Project Engineer     \/|\/|\/|\/  Common Systems           |

| Tel: +47 51 50 63 75  \|/\|/\|/   Bjergstedveien 1         |

| Fax: +47 51 50 65 00	 -------    P.O. Box 330             |

|                                   N-4001 Stavanger, NORWAY |


| Email: peres_at_stavanger.geco-prakla.slb.com                 |


--------------------------------------------------------------