0
votes
2answers
3k views

ORA-04031: unable to allocate 4708660 bytes of shared memory

I am running Oracle 11g R1 on my local development machine. I have been trying to run an anonymous block to test the FORALL statement in Oracle to insert 25,000 records. I get the following error: ...
4
votes
3answers
3k views

Unable to start Oracle (11g1) due to bad memory configuration (ORA-00837)

I decided to reduce the memory allocation of a local developer instance, and was told that the following command did the job; alter system set memory_max_target = 512M scope = spfile; Which I guess ...