Re: FW: Concurrent Manager

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