Re: Re: Free Shared pool memory

Jonathan Lewis,

		Hi, lewis,have you ever see any big system with large shared pool size? This week I saw a mobile telecom system running ops 8163, have 8GB sga, with 3GB of shared_pool_size and About 5GB of data buffer.(Physical memory is  16GB)
		I never configured a system with shared_pool_size larger than 200MB(my current system is 200MB).But that oracle is installed by oracle china, so i wonder if this kind of configuration is reasonable? I do not have enough time to analyze that system, but I do not think Oracle china is giving the customer the right parameter about shared_pool, can you give your opinion?
	Thanks.

Regards
zhu chao
msn:chao_ping_at_163.com
www.happyit.net
www.cnoug.org(ChinaOracle User Group)

• 2003-01-02 02:28:00 ,you wrote£º=======

>I think it's safe to say that if the free memory is always very large
>then you can reinterpret it as 'wasted memory'.
>
>If the free memory is alway very small, I don't think it is possible
>to make any decision without know the application. It is possible
>that you need to increase the shared pool slightly (good app), it is
>also possible that your shared pool is just about the right size
>(great
>app) , but it is possible that your application design has a flaw in
>it.
>
>
>Regards
>
>Jonathan Lewis
>http://www.jlcomp.demon.co.uk
>
>Coming soon a new one-day tutorial:
>Cost Based Optimisation
>(see http://www.jlcomp.demon.co.uk/tutorial.html )
>
>Next Seminar dates:
>(see http://www.jlcomp.demon.co.uk/seminar.html )
>
>____England______January 21/23
>
>
>The Co-operative Oracle Users' FAQ
>http://www.jlcomp.demon.co.uk/faq/ind_faq.html
>
>
>
>
>
>-----Original Message-----
>To: Multiple recipients of list ORACLE-L <ORACLE-L_at_fatcity.com>
>Date: 02 January 2003 05:39
>
>
>>
>>Is it Correct to Look at FREE Memory in the Shared Pool ?
>>Memory when used once thereafter when NO Longer in use does the FREE
>Memory again Come up ?
>>Are there any ideal Values for percentage of Free memory for the
>Shared Pool
>>
>>The Respective Hybrid Application mostly uses Bind Variables
>>
>>Thanks
>>
>>
>>
>>--
>>Please see the official ORACLE-L FAQ: http://www.orafaq.net
>>--
>>Author: VIVEK_SHARMA
>> INET: VIVEK_SHARMA_at_infosys.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).
>>
>
>--
>Please see the official ORACLE-L FAQ: http://www.orafaq.net
>--
>Author: Jonathan Lewis
> INET: jonathan_at_jlcomp.demon.co.uk
>
>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: chao_ping
  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).