Paul Dembry wrote:
>
> I am also getting a 4031 error but I'm not running any procedures, just a very large
> SQL
> statement (7864 bytes). The error specifically mentions the sql area and cursor
> execute
> memory. Is there something I can change in the init.ora parms?
>
> Thanks,
> Paul
Increase shared_pool_size. You'll have to experiment for the correct size.
Much depends on how much physical memory you have and how big the largest
shared memory segment can be (UNIX only).
Received on Fri Oct 29 1999 - 14:53:32 CDT
