Re: need help - buffer overflow

IF set arraysize 1 doesn't work, try:

   alter system flush shared_pool;

If this works, then your sharedpool must be fragmented:

1. You might want to add to the SHARED_POOL_SIZE variable in init<SID>.ora.
2. Might want to pin some of your large packages so that they get a contiguous amount of memory within shared_pool.