SEO

#1 (**permalink**) 02-26-2008, 05:59 PM

I have rather large LOB objects and I get the error "not enough memory
to process statement" -- I increased the query_heap_sz directly on the
server, but cannot do this on the runtime client since this option is
not available for the client. How do I get rid of this error on the
client? I am using java and jdbc. Thank you very much.

#2 (**permalink**) 02-26-2008, 05:59 PM

This parameter is meaningless on the client - query_heap is only used on
the server. The server will need to be stopped and restarted for the new
value to take effect.

sea wrote:
> I have rather large LOB objects and I get the error "not enough memory
> to process statement" -- I increased the query_heap_sz directly on the
> server, but cannot do this on the runtime client since this option is
> not available for the client. How do I get rid of this error on the
> client? I am using java and jdbc. Thank you very much.

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

SEO

query_heap_sz on client?