RE: About an old hint question

John,

Thanks for the info.

Stephane

-----Original Message-----
Kanagaraj
Sent: Wednesday, May 14, 2003 9:22 PM
To: Multiple recipients of list ORACLE-L

Stephane,

Just to clarify: Hints (or any changes for that matter) provided by Developers *other than* Oracle Apps dev are forbidden in the 'canned' (or standard) version of Oracle Apps 11i. (see the link below)

http://metalink.oracle.com/metalink/plsql/ml2_documents.showFrameDocument?p_ database_id=NOT&p_id=169935.1

The article does specify a number of both documented and undocumented init.ora parameters that are fixed for Apps 11i. When a performance issue in 'standard' code is reported to the 11i, they will (supposed to) resolve the problem via a patch. Now the patch may contain hints (and many do) to resolve the issue. Any changes by the user would NOT have been supported by Oracle Apps support.

Hints could be added in the Custom code though. Fyi, up until Apps 11i, Oracle's own ERP Suite ran on the RBO (very successfully, and on a very large number of sites with fairly large Dbs I might add).

John Kanagaraj
Oracle Applications DBA
DBSoft Inc
(W): 408-970-7002

I don't know what the future holds for me, but I do know who holds my future!

• The opinions and statements above are entirely my own and not those of my employer or clients **

> -----Original Message-----
> From: Stephane Paquette [mailto:stephane.paquette_at_standardlife.ca]
> Sent: Wednesday, May 14, 2003 1:22 PM
> To: Multiple recipients of list ORACLE-L
> Subject: About an old hint question
>
>
> Hi,
>
> Some weeks ago, I post a question on the future of hints.
> Today, as I was browsing on asktom, I found this :
>
> In Oracle Applications development (11i apps - HR, CRM, etc) Hints are
> strictly
> forbidden. We find the underlying cause and fix it.
>
> The link is
> :http://asktom.oracle.com/pls/ask/f?p=4950:8:16964891103379065
> 2::NO::F4950_P
> 8_DISPLAYID,F4950_P8_CRITERIA:7038986332061,
>
>
>
> Stephane Paquette
> Administrateur de bases de donnees
> Database Administrator
> Standard Life
> www.standardlife.ca
> Tel. (514) 925-7187
> stephane.paquette_at_standardlife.ca
> <mailto:stephane.paquette_at_standardlife.ca>
>
>
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.net
> --
> Author: Stephane Paquette
> INET: stephane.paquette_at_standardlife.ca
>
> Fat City Network Services -- 858-538-5051 http://www.fatcity.com
> San Diego, California -- Mailing list and web hosting services
> ---------------------------------------------------------------------
> 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).
>

--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: John Kanagaraj
  INET: john.kanagaraj_at_hds.com

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services
---------------------------------------------------------------------
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).

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Stephane Paquette
  INET: stephane.paquette_at_standardlife.ca

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services
---------------------------------------------------------------------
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).