ORA-04031：unable to allocate 140 bytes of shared memory.
929791Apr 23 2012 — edited Apr 24 2012Hi there~
I know that the 4031 error is not a new issue, but somehow I can't find a best solution from thousands lines of suggestions and articles. Since I'm new to ORACLE, I'm really baffled by those complicated answers. My problem is: I'm trying to register a xml schema in xml db, then the error 04031 props. My databas version is 11g R2 express edition. And I've read the "express edition 2 day", which seems to suggest that "simply altering sga target/pga will solve the problem". I did as follow:
ALTER SYSTEM SET pga_aggregate_target =300M;
ALTER SYSTEM SET sga_target = 600 M;
I don't know how to set those parameters, and the default "shared pool size" is "0". After I've done this, the error 04013 still there.
Could anyone kind enough to show me a clear way to conifigour all these values ??? Thanks a million!