Tuesday, October 2, 2012

ORA-04031 and the shared pool

We often get this kind of error:

BEA-001129 Received exception while creating connection for pool "PIPPODataSourceASIA": ORA-04031: unable to allocate 32 bytes of shared memory ("shared pool","DATABASESYS","trigger inform","kglhin: temp")
osbpr1do.log00252:ORA-04031: unable to allocate 32 bytes of shared memory ("shared pool","select name,password,datats#...","sql area","tmp")


the SQL statement changes, but the "shared pool" is always the same.

First we need to understand what a "shared pool" is:

http://www.dba-oracle.com/concepts/shared_pool_concepts.htm

the "shared pool" is part of the http://en.wikipedia.org/wiki/Oracle_Database#System_Global_Area

It turns out that the DB parameters had to be tuned. No settings on WebLogic side can fix the issue.

No comments: