You cannot control the sizes of sql area and library cache individually Regards ============
On Thu, 25 Sep 2003 ManojKr Jha wrote : > > > >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: [EMAIL PROTECTED] > >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: [EMAIL PROTECTED] (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). ___________________________________________________ Art meets Anesthesia; Shefali Weds Dr. Raman. Rediff Matchmaker strikes another interesting match !! Visit http://matchmaker.rediff.com?1 -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: bhabani s pradhan INET: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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).