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_at_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_at_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_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.net
--
Author: zhu chao
INET: chao_ping_at_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_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).
Received on Thu Sep 25 2003 - 02:24:39 CDT
