|
Problem IT15627
|
Status: Closed |
OPTIMIZER NEEDS A LOT OF SHARED MEMORY
|
| product: |
INFORMIX SERVER / 5725A3900 / C10 - IDS 12.10 |
| Problem description: |
Optimizing a query needs much more shared memory in 12.10.FC6
compared to 12.10.FC5.
After running a query (with AVOID_EXECUTE) a lot of shared
memory segments were allocated. |
| Problem Summary: |
****************************************************************
* USERS AFFECTED: *
* Users of 12.10.xC6 through 12.10.xC12 (inclusive). *
****************************************************************
* PROBLEM DESCRIPTION: *
* Optimizing a query needs much more shared memory in *
* 12.10.xC6 - 12.10.xC12 compared to 12.10.FC5. *
* *
* After running a query a lot of shared memory segments were *
* allocated. *
****************************************************************
* RECOMMENDATION: *
* Upgrade to IDS 12.10.xC13+. *
****************************************************************
The fix can be disabled by setting OPT_ANSIJOIN_P1PRUNE to a big
number like 100:
onmode -wm OPT_ANSIJOIN_P1PRUNE=100 |
| Local Fix: |
|
| Solution |
|
| Workaround |
not known / see Local fix |
| Timestamps |
Date - problem reported :
Date - problem closed :
Date - last modified :
| 07.06.2016
31.10.2019
31.10.2019 |
| Problem solved at the following versions (IBM BugInfos) |
12.10.xC13,
12.10.xC8
|
| Problem solved according to the fixlist(s) of the following version(s) |
