Re: 11i Conc. Manager Question

Please explain how the shared pool is involved and how flushing it will help?

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

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

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