Unanswered: Unable to allocate Shared Memory Error
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,
Thanks and Regards,