FW: Concurrent Manager

From: Tim Gorman <tim_at_sagelogix.com>
Date: Sun, 12 Oct 2003 10:39:28 -0800
Message-ID: <F001.005D2E07.20031012103928@fatcity.com>

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).

Received on Sun Oct 12 2003 - 13:39:28 CDT