Oracle-L: RE: Concurrent Manager

From: April Wells <awells_at_csedge.com>
Date: Tue, 14 Oct 2003 04:59:32 -0800
Message-ID: <F001.005D310E.20031014045932@fatcity.com>

But every time I open an ITar, Support freaks because we have ours configured with the managers on the middle tier (Windows might be the issue, but that isn't usually when they balk) and not on the database tier...

and if you do a 2 tier install (at least as of 11.5.5) it assumes you want the CM on the database tier...

April Wells
Oracle DBA/Oracle Apps DBA
Corporate Systems
Amarillo Texas
/\
/ \

/     \
\     /

\/
>\<

     \
     >\<
         \

Few people really enjoy the simple pleasure of flying a kite Adam Wells age 11

-----Original Message-----
Sent: Monday, October 13, 2003 5:24 PM
To: Multiple recipients of list ORACLE-L

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

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

The information contained in this communication, including attachments, is strictly 
confidential and for the intended use of the addressee only; it may also contain 
proprietary, price sensitive, or legally privileged information. Notice is hereby given that 
any disclosure, distribution, dissemination, use, or copying of the information by anyone 
other than the intended recipient is strictly prohibited and may be illegal. If you have 
received this communication in error, please notify the sender immediately by reply e-mail, 
delete this communication, and destroy all copies.
 

Corporate Systems, Inc. has taken reasonable precautions to ensure that any attachment to 
this e-mail has been swept for viruses. We specifically disclaim all liability and will 
accept no responsibility for any damage sustained as a result of software viruses and advise 
you to carry out your own virus checks before opening any attachment.

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: April Wells
  INET: awells_at_csedge.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 Tue Oct 14 2003 - 07:59:32 CDT