Hi All,

I am using Oracle 9i. I am trying to create a request in Kintana. Whenever i try to create a request, i get the oracle shared memory error. Previously i allocated 50 MB shared memory and now i increased to 500 MB. Then also i am getting the same error as "ORA-04031: unable to allocate 8704 bytes of shared memory ("large pool","unknown object","hash-join subh","kllcqas:kllsltba")".

I increased the size of shared memory in init.ora file and re-created the spfile and restarted the database. I checked the new value of shared memory and it has been changed to 500 MB.

Can anyone tell me what could be the problem

Thanks in advance,