'course you have otherwise it wouldn't be trying to allocate memory from your shared_pool... Have you tried increasing the size of your shared pool so that Oracle can find a sufficient chuck of memory to allocate to your request?