ORA-04031: unable to allocate 16 bytes of shared memory
mariusNov 17 2005 — edited Nov 21 2005Hi,
I tried to create an application with HTMLDB.
After I got to the finish this error appeared:
ORA-00604: error occurred at recursive SQL level 1
ORA-04031: unable to allocate 16 bytes of shared memory ("shared pool","select job, nvl2(last_date, ...","sql area","kglhin: temp")
After this error appeared, HTMLDB interface woudn't work.
I tried to login with pl/sql developer - it said the same thing. The second time I could connect.
I understand It has something to do whith "More shared memory is needed than was allocated in the shared pool".
Do I have to change the SGA TARGET, or alter the setting <open_cursors=300> in spfileexe.ora?
I installed Oracle XE on my home computer with 512 MB RAM, on Windows XP SP2.
SGA Component Computed Current
Allocation (MB)
Shared Pool 60
Buffer Cache 16
Other 16
Total 92
Current PGA Allocated (MB): 39
Maximum PGA Allocated (MB): 39