Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> re _sqlexec_progression_cost -- again

re _sqlexec_progression_cost -- again

From: Hemant K Chitale <hkchital_at_singnet.com.sg>
Date: Sun, 04 Aug 2002 07:13:17 -0800
Message-ID: <F001.004AAE04.20020804071317@fatcity.com>


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)
  3. 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: hkchital_at_singnet.com.sg

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: ListGuru_at_fatcity.com (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). Received on Sun Aug 04 2002 - 10:13:17 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US