Re: 11i Conc. Manager Question

Also try to flush your sharepool at that time when users complaining about slow pick up of concurrent requests...Congested sharedpool also contribute towards slowness....

alter system flush shared_pool;

Regard
Rafiq

Reply-To: ORACLE-L_at_fatcity.com
To: Multiple recipients of list ORACLE-L <ORACLE-L_at_fatcity.com> Date: Tue, 13 Aug 2002 06:33:28 -0800

Sure, you can take the sleep down to as low as 30seconds.

Hemant
At 04:53 AM 13-08-02 -0800, you wrote:
>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).

Hemant K Chitale
Now using Eudora Email. Try it !

My home page is : http://hkchital.tripod.com

--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Hemant K Chitale
  INET: hkchital_at_singnet.com.sg

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




_________________________________________________________________
Chat with friends online, try MSN Messenger: http://messenger.msn.com

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Mohammad Rafiq
  INET: rafiq9857_at_hotmail.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).