Message-ID: <F001.005D0F7E.20030924232439@fatcity.com>
Date: Wed, 24 Sep 2003 23:24:39 -0800
To: Multiple recipients of list ORACLE-L <ORACLE-L@fatcity.com>
Sender: ml-errors@fatcity.com
Reply-To: ORACLE-L@fatcity.com
Errors-To: ML-ERRORS@fatcity.com
From: "zhu chao" <chao_ping@vip.163.com>
Subject: Re: "SQL AREA" and "LIBARARY CACHE" size?
Organization: Fat City Network Services, San Diego, California
Precedence: bulk
Mime-Version: 1.0
Content-Type: text/plain;	charset="iso-8859-1"
Content-Transfer-Encoding: 8bit

There is no control on these parameter. Oracle manage it by itself. Only one parameter: shared_pool_size.
    

----- Original Message ----- 
To: "Multiple recipients of list ORACLE-L" <ORACLE-L@fatcity.com>
Sent: Thursday, September 25, 2003 3:09 PM


> 
> 
> 
> Hi,
> 
> Any body have any idea about how to control the size of "library cache" and
> "sql area" in shared_pool?
> 
> With Regards,
> Manoj Kumar Jha
> ----------------------------------------------------------------------------------------------------
> 
> 
> A transcendentalist engaged in auspicious activities does not meet with
> destruction either in this world or in the spiritual world; one who does
> good,
> is never overcome by evil.
> ----------------------------------------------------------------------------------------------------
> 
> DISCLAIMER: The information contained in this message is intended only and
> solely for the addressed individual or entity indicated in this message and
> for the exclusive use of the said addressed individual or entity indicated
> in this message (or responsible for delivery of the message to such person)
> and may contain legally privileged and confidential information belonging
> to Tata Consultancy Services. It must not be printed, read, copied,
> disclosed, forwarded, distributed or used (in whatsoever manner) by any
> person other than the addressee. Unauthorized use, disclosure or copying is
> strictly prohibited and may constitute unlawful act and can possibly
> attract legal action, civil and/or criminal. The contents of this message
> need not necessarily reflect or endorse the views of Tata Consultancy
> Services on any subject matter. Any action taken or omitted to be taken
> based on this message is entirely at your risk and neither the originator
> of this message nor Tata Consultancy Services takes any responsibility or
> liability towards the same. Opinions, conclusions and any other information
> contained in this message that do not relate to the official business of
> Tata Consultancy Services shall be understood as neither given nor endorsed
> by Tata Consultancy Services or any affiliate of Tata Consultancy Services.
> If you have received this message in error, you should destroy this message
> and may please notify the sender by e-mail. Thank you.
> 
> -- 
> Please see the official ORACLE-L FAQ: http://www.orafaq.net
> -- 
> Author: ManojKr Jha
>   INET: jmanoj@delhi.tcs.co.in
> 
> 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@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.net
-- 
Author: zhu chao
  INET: chao_ping@vip.163.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@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).