BEA-001129 Received exception while creating connection for pool "PIPPODataSourceASIA": ORA-04031: unable to allocate 32 byt
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:
Post a Comment