Re: Concurrent Manager

From: Tim Gorman <tim_at_sagelogix.com>
Date: Mon, 13 Oct 2003 14:24:26 -0800
Message-ID: <F001.005D2F5F.20031013142426@fatcity.com>

You are absolutely correct for Apps 11.0.x and before. And I'm not saying that some performance is not lost due to network latency for some ConcMgr programs.

But it ain't as bad as it used to be, because of the steady migration away from "chatty" PRO*C and Reports code to more "network-friendly" stored procedures.

At this point, you have to decide where to take your lumps: in manageability by bucking the suggested configuration, or in ConcMgr performance...

on 10/13/03 8:49 AM, Hemant K Chitale at hkchital_at_singnet.com.sg wrote:

> 
> Well, I guess there's something more for me to learn.
> 
> The last time I did an 11i install was more than 2.5 years ago, as a
> consultant,
> installing 11.5.3
> Since then, I've been administering an 11.0.3 environment [alongwith 50
> other databases].
> 
> Hemant
> At 10:39 AM 12-10-03 -0800, you wrote:

>> It is incredibly annoying when the listserver truncates a response. Here it
>> is in its entirety...
>>
>>
>> ------ Forwarded Message
>> Date: Sun, 12 Oct 2003 11:06:38 -0700
>> To: <ORACLE-L_at_fatcity.com>
>>
>> Hemant,
>>
>> That configuration was usual for Apps 11.0.x and prior, but with 11i it is
>> strongly recommended to take the default configuration and leave the ConcMgr
>> on the apps-tier instread of the db-tier.
>>
>> Two major reasons:
>>
>> * The gains in manageability (especially upgrades) far outweigh the
>> incremental (possible) loss in performance. For tuning, tune the SQL, don¹t
>> assume its network. For example, upgrading the db-tier is now a snap, as
>> compared to performing such an upgrade for 10.7 or 11.0.x...
>>
>> * There is not as much network back-and-forth in 11i batch programs and
>> reports as there used to be. Enormous numbers of stored procedures and
>> packages are now being used, making the ConcMgr programs much less ³chatty².
>> By way of example, I recently performed a ³utlirp.sql² run as part of an
>> RDBMS upgrade for Oracle Financials 11.0.3 (from 8.0.5 to 8.1.7) and about
>> 30,000 compiled objects were invalidated and then recompiled. In contrast,
>> I recently also performed the same ³utlirp.sql² for an 11.5.8 Financials
>> upgrade (from 8.1.7 to 9.2.0) and just under 200,000 compiled objects where
>> invalidated then recompiled.
>>
>> Again, everything is a trade-off. You might incur some loss due to network
>> latency, but is network latency the biggest problem to pay attention to?
>>
>> Just another example of how the only constant is change...
>>
>> -Tim
>>
>> on 10/12/03 8:59 AM, Hemant K Chitale at hkchital_at_singnet.com.sg wrote:
>>

>>> 
>>> I keep Concurrent Managers on the DB server because the managers fire off
>>> child processes
>>> to run all requests and I do not want report jobs submitted by users

>> that are

>>> actually large batch-jobs
>>> running over SQLNet.  It would be the old Client-Server issue where

>> Reports on

>>> a Client ran
>>> slower because of the overhead of the SQLNet round-trips.
>>> 
>>> Hemant
>>> 
>>> At 04:10 AM 09-10-03 -0800, you wrote:
>>>> Hi ,
>>>> In Oracle Apps why concurrent manager and report server
>>>> should be in database tier when other application servers
>>>> are in application tier.?
>>>> 
>>>> Thx
>>>> 
>>> Hemant K Chitale
>>> Oracle 9i Database Administrator Certified Professional
>>> My personal web site is : http://hkchital.tripod.com
>>> <http://hkchital.tripod.com/>
>>> 
>>> -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author:
>>> Hemant K Chitale INET: hkchital_at_singnet.com.sg 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).

>>
>>
>> ------ End of Forwarded Message
>>
>> --
>> Please see the official ORACLE-L FAQ: http://www.orafaq.net
>> --
>> Author: Tim Gorman
>> INET: tim_at_sagelogix.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).

> 
> Hemant K Chitale
> Oracle 9i Database Administrator Certified Professional
> My personal web site is :  http://hkchital.tripod.com
> 

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Tim Gorman
  INET: tim_at_sagelogix.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).

Received on Mon Oct 13 2003 - 17:24:26 CDT