Optimize memory

memoryjakinsg@acslink.net.au (Graham Jakins) wrote:
>N.Summersall@bradford.ac.uk (N SUMMERSALL) wrote:
>
>
>>I am running Ingres v6.4 on Hp-UX8.07. When I carry out a simple update frame
>>which retrieves information from the master and appends detail to table I get
>>the following error message;
>
>>Optimizer ran out of memory before generating execution plan (E_QP0002).
>
>This is related to the stotage that the Query Optimizer Facility needs
>to determine the optimal plan for the query being run - could be a
>fairly complex query being generated.
>
>>This update really is trivial. What memory is the optimizer using and how
>>can I prevent it running out?
>
>To prevent this message happening you can add an option to the
>rundbms.opt file in the directory $II_SYSTEM/ingres/files
>This is of the format 
>	-opf.memory nnnnnnn
>Check the Ingres Installation and Ops guide for the default values.
>The new value will not take effect until Ingres is shutdown and re-started.
>
>Its almost a "suck it and see" value - increase until the query works.
>If the value gets too large you may need to revisit the query to simplify it.
>
>>Thanks
>
>>Neil
>
>
>+------------------------+--------------------------+
>|     Graham Jakins      |  Ganda Systems           |
>|                        |  11 Delwood Place        |
>|   Systems Consultant   |  Willetton  6155         |
>|                        |  Western Australia       |
>| jakinsg@acslink.net.au |  Voice +61 9 310 9994    |
>|                        |  Fax   +61 9 313 5808    |
>+------------------------+--------------------------+  
>

Don't forget that this also takes more memory away from the operating 
system for general use (eg cache) so be careful how much extra memory you 
assign for the optimiser. The default amount of memory used is (200,000 * 
number of sessions). We had a similar problem some time ago and overcane 
the problem by increasing the memory from the default 6,400,000 (200,000 
* 32) to 9,600,000.
-- 
======================================================================

There are two types of people in this world:

Those who believe there are two types of people and those that don't.

======================================================================
Ingres Q & A
To William's Home Page
Email William