Hi,
Increase the LARGE_POOL_SIZE and then try it out.This error is occuring because the shared pool has become fragmented and there is no contignous memory available for ur query to execute.

Regards,
Rohit Nirkhe,Oracle/Apps DBA,OCP 8i
[email protected]