Re: 11i Conc. Manager Question

Jay,

It's a little more complicated than that. It sounds like you are using the single default ConcMgr queue (named "standard", if I recall correctly?) and you really should designate different "jobs" to go to different queues, each of which is configured (in terms of managers and sleep times) according to business requirements...

Barb Matthews wrote an excellent paper entitled "Herding Cats" back in 1996 or so. Definitely pre-R11i, but certainly as relevant today as for R9.4 or whatever she was running at the time. The paper can be found online at her website at http://www.OnCallDBA.com and it should provide some good guidance on setting up queues for your own particular environment and requirements, even if the ConcMgr terminology has maybe changed for R11i...

Hope this helps...

-Tim

• Original Message ----- To: "Multiple recipients of list ORACLE-L" <ORACLE-L_at_fatcity.com> Sent: Tuesday, August 13, 2002 6:53 AM

For those of you running Oracle Applications 11i, have you modified the cache or sleep time for the standard managers? Ours remains at the default, which is cache 1 and sleep null (which I think defaults to 60 seconds). Users are complaining about the system being "slow." When I checked it out, they are just getting impatient waiting for concurrent requests to get picked up by the managers - sometimes it takes as "long" as 2 minutes.

Thanks,

Jay Hostetter
Oracle DBA
D. & E. Communications
Ephrata, PA USA

**DISCLAIMER
This e-mail message and any files transmitted with it are intended for the use of the individual or entity to which they are addressed and may contain information that is privileged, proprietary and confidential. If you are not the intended recipient, you may not use, copy or disclose to anyone the message or any information contained in the message. If you have received this communication in error, please notify the sender and delete this e-mail message. The contents do not represent the opinion of D&E except to the extent that it relates to their official business.

--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Jay Hostetter
  INET: jhostetter_at_decommunications.com

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
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.com
-- 
Author: Tim Gorman
  INET: Tim_at_SageLogix.com

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
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).