I'm getting an ORA-04031: unable to allocate 8192 bytes of shared memory (large
pool,unknown object,sort subheap,sort key) error, and am having a hard time
solving the issue.
The SQL being ran is:
SELECT COUNT(DISTINCT mail) theCount
FROM Demo D
WHERE (EXISTS (SELECT 1 FROM mails WHERE mail =
[[EMAIL PROTECTED]]
I'm getting an ORA-04031: unable to allocate 8192 bytes of shared
memory (large pool,unknown object,sort subheap,sort key) error,
and am having a hard time solving the issue.
http://www.cryer.co.uk/brian/oracle/ORA04031.htm
--
James Manning [EMAIL PROTECTED]
GPG Key