[Info-Ingres] Optimizer Ran out of memory

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

BODH RAJ - 27 Aug 2004 08:01 GMT

Which part in CBF needs to be increased to resolve
this issue :

E_OP0002 optimizer ran out of
memory before generating execution plan

Bodh Raaj

__________________________________________________
Do You Yahoo!?
Tired of spam? Yahoo! Mail has the best spam protection around
http://mail.yahoo.com

Reply to this Message

David Richard - 27 Aug 2004 08:53 GMT

cbf->DBMS Server->Derived-opf_memory

************************************************************************
DISCLAIMER
The information contained in this e-mail is confidential and is intended
for the recipient only.
If you have received it in error, please notify us immediately by reply
e-mail and then delete it from your system. Please do not copy it or
use it for any other purposes, or disclose the content of the e-mail
to any other person or store or copy the information in any medium.
The views contained in this e-mail are those of the author and not
necessarily those of Admenta UK Group.
************************************************************************

Reply to this Message

Roy Hann - 27 Aug 2004 09:21 GMT

> Which part in CBF needs to be increased to resolve
> this issue :
>
> E_OP0002 optimizer ran out of
> memory before generating execution plan

opf_memory. It is a derived DBMS server parameter, so you will need to
protect it if you change it.

(Or you could try just giving the problem query a bigger chunk of the memory
you're already allocating, by increasing opf_maxmemf.)

Roy Hann (rhann at rationalcommerce dot com)
Rational Commerce Ltd.
www.rationalcommerce.com
"Ingres development, tuning, and training experts"

Reply to this Message