Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: CBO influences
Bingo! My partner had assured me that he had checked the
initialization parms and they were all identical. When I looked at the
10053 trace where all the optimizer related parms were grouped together
I discovered that OPTIMIZER_INDEX_CACHING, OPTIMIZER_INDEX_COST_ADJ,
and OPTIMIZER_MAX_PERMUTATIONS were different.
Received on Fri Sep 09 2005 - 14:32:44 CDT