The first two or three 11i releases were built on 8.1.6
Setting _sqlexec_progression_cost to 0 has been recommended
for 11i as per
1) Note 169935.1 (Troubleshooting ERP Apps Performance Issues)
2) Note 174605.1 (Current, required, recommended Apps 11i init.ora
parameters)
{In fact this note also sets it as required at 0 against both 8.1.7 and 9.0.1)
2) Note 148903.1 (InterOperability Notes Oracle Applications 11i with 8.1.7)
My question relates to Oracle Applications 11.0 (11.0.3)
which was built against 8.0.4 and 8.0.5. Per the
Applications 11.0 InterOperability Notes with 8.1.7,
_sqlexec_progression_cost must be set to 0 after upgrading
the database to 8.1.7 if the upgrade is part of a planned
upgrade of the applications from 11.0 to 11i.
However, there is no specific mention about setting this
paramter if running 11.0 against 8.1.7
11.0 was built with the Rule Based optimizer and optimizer_mode=RULE
is required even against 8.1.7 but 11i was built with the Cost Based
optimizer.
My question was whether _sqlexec_progression_cost=0 is specifically
for Cost Based (or CHOOSE) optimizer databases as that is the only
difference between 11.0 and 11i against 8.1.7. Per my reading
of the 62143.1 and 68955.1 there is no specific reference
about the optimizer mode. Therefore, I believe that this parameter
also applies in a Rule based database -- ergo an 11.0 database.
So I would think that it makes sense to set _sqlexec_progression_cost to 0
even when running 11.0 and Rule-based.
Although Bug 1210242 mentioned in note 68955.1 says that the bug
is fixed in 8.1.7, it doesn't seem to have been fixed -- as
apparent in notes 169935.1 and 174605.1.
Hemant
Hemant K Chitale
Now using Eudora Email. Try it !
My home page is : http://hkchital.tripod.com
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Hemant K Chitale
INET: [EMAIL PROTECTED]
Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
San Diego, California -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).
